Name Game
You can find the complete source code for this model here.
The Data set consists of name, gender, state and year with the number of people that were born with that name in that gender, state and year.
query: table('bigquery-public-data.usa_names.usa_1910_2013') -> { top: 10 project: * }
| state | gender | year | name | number |
|---|---|---|---|---|
| AK | F | 1,910 | Elsie | 6 |
| AL | F | 1,910 | Annie | 482 |
| AL | F | 1,910 | Katie | 84 |
| AL | F | 1,910 | Alma | 82 |
| AL | F | 1,910 | Thelma | 65 |
| AL | F | 1,910 | Ellen | 38 |
| AL | F | 1,910 | Rebecca | 35 |
| AL | F | 1,910 | Estella | 21 |
| AL | F | 1,910 | Corine | 17 |
| AL | F | 1,910 | Margie | 17 |
[ { "state": "AK", "gender": "F", "year": 1910, "name": "Elsie", "number": 6 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Annie", "number": 482 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Katie", "number": 84 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Alma", "number": 82 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Thelma", "number": 65 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Ellen", "number": 38 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Rebecca", "number": 35 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Estella", "number": 21 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Corine", "number": 17 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Margie", "number": 17 } ]
SELECT base.state as state, base.gender as gender, base.year as year, base.name as name, base.number as number FROM `bigquery-public-data.usa_names.usa_1910_2013` as base LIMIT 10
The command above says query the table 'bigquery-public-data.usa_names.usa_1910_2013' and project (show)
all the columns for the first 10 rows.
Grouping a query
In SQL there are basically two kinds of SELECT commands: SELECT ... GROUP BY and SELECT without a grouping.
In Malloy, these are two different commands. The command in Malloy for SELECT ... GROUP BY is group_by. Since number
and year are reserved words, we have to quote the names with back-tics.
query: table('bigquery-public-data.usa_names.usa_1910_2013') -> { group_by: name aggregate: population is `number`.sum() }
| name | population |
|---|---|
| James | 4,942,431 |
| John | 4,834,422 |
| Robert | 4,718,787 |
| Michael | 4,297,230 |
| William | 3,822,209 |
| Mary | 3,737,679 |
| David | 3,549,801 |
| Richard | 2,531,924 |
| Joseph | 2,472,917 |
| Charles | 2,244,693 |
| Thomas | 2,212,781 |
| Christopher | 1,987,490 |
| Daniel | 1,842,964 |
| Patricia | 1,569,570 |
| Matthew | 1,538,689 |
| Elizabeth | 1,492,404 |
| Jennifer | 1,463,145 |
| Linda | 1,447,601 |
| Barbara | 1,424,203 |
| Donald | 1,402,666 |
| Anthony | 1,385,453 |
| Paul | 1,355,711 |
| Mark | 1,339,371 |
| George | 1,321,652 |
| Steven | 1,269,627 |
| Kenneth | 1,259,720 |
| Andrew | 1,228,080 |
| Edward | 1,210,315 |
| Joshua | 1,163,481 |
| Brian | 1,156,495 |
| Kevin | 1,148,680 |
| Margaret | 1,120,766 |
| Susan | 1,108,712 |
| Ronald | 1,074,141 |
| Timothy | 1,055,792 |
| Dorothy | 1,052,570 |
| Jessica | 1,038,359 |
| Jason | 1,009,416 |
| Sarah | 1,006,934 |
| Betty | 985,364 |
| Nancy | 984,185 |
| Karen | 982,192 |
| Jeffrey | 969,093 |
| Lisa | 962,981 |
| Ryan | 907,969 |
| Gary | 896,637 |
| Helen | 895,428 |
| Sandra | 870,958 |
| Nicholas | 867,231 |
| Eric | 862,204 |
| Jacob | 848,518 |
| Stephen | 844,930 |
| Ashley | 841,427 |
| Donna | 826,714 |
| Kimberly | 826,275 |
| Frank | 818,197 |
| Carol | 817,290 |
| Jonathan | 803,723 |
| Michelle | 803,162 |
| Larry | 801,398 |
| Emily | 779,755 |
| Amanda | 769,292 |
| Scott | 765,844 |
| Justin | 757,273 |
| Laura | 745,892 |
| Melissa | 745,498 |
| Raymond | 744,284 |
| Deborah | 735,869 |
| Brandon | 735,849 |
| Stephanie | 732,651 |
| Rebecca | 728,799 |
| Ruth | 728,678 |
| Anna | 719,803 |
| Sharon | 718,701 |
| Kathleen | 703,265 |
| Cynthia | 703,175 |
| Gregory | 701,504 |
| Shirley | 686,079 |
| Samuel | 681,358 |
| Amy | 673,234 |
| Benjamin | 664,328 |
| Patrick | 655,434 |
| Angela | 653,663 |
| Jack | 634,113 |
| Virginia | 621,448 |
| Jerry | 618,105 |
| Dennis | 610,894 |
| Catherine | 606,029 |
| Brenda | 604,067 |
| Alexander | 598,944 |
| Katherine | 593,220 |
| Pamela | 591,307 |
| Nicole | 576,870 |
| Tyler | 576,031 |
| Christine | 574,120 |
| Henry | 571,539 |
| Walter | 558,026 |
| Peter | 553,789 |
| Douglas | 552,666 |
| Janet | 550,557 |
[ { "name": "James", "population": 4942431 }, { "name": "John", "population": 4834422 }, { "name": "Robert", "population": 4718787 }, { "name": "Michael", "population": 4297230 }, { "name": "William", "population": 3822209 }, { "name": "Mary", "population": 3737679 }, { "name": "David", "population": 3549801 }, { "name": "Richard", "population": 2531924 }, { "name": "Joseph", "population": 2472917 }, { "name": "Charles", "population": 2244693 }, { "name": "Thomas", "population": 2212781 }, { "name": "Christopher", "population": 1987490 }, { "name": "Daniel", "population": 1842964 }, { "name": "Patricia", "population": 1569570 }, { "name": "Matthew", "population": 1538689 }, { "name": "Elizabeth", "population": 1492404 }, { "name": "Jennifer", "population": 1463145 }, { "name": "Linda", "population": 1447601 }, { "name": "Barbara", "population": 1424203 }, { "name": "Donald", "population": 1402666 }, { "name": "Anthony", "population": 1385453 }, { "name": "Paul", "population": 1355711 }, { "name": "Mark", "population": 1339371 }, { "name": "George", "population": 1321652 }, { "name": "Steven", "population": 1269627 }, { "name": "Kenneth", "population": 1259720 }, { "name": "Andrew", "population": 1228080 }, { "name": "Edward", "population": 1210315 }, { "name": "Joshua", "population": 1163481 }, { "name": "Brian", "population": 1156495 }, { "name": "Kevin", "population": 1148680 }, { "name": "Margaret", "population": 1120766 }, { "name": "Susan", "population": 1108712 }, { "name": "Ronald", "population": 1074141 }, { "name": "Timothy", "population": 1055792 }, { "name": "Dorothy", "population": 1052570 }, { "name": "Jessica", "population": 1038359 }, { "name": "Jason", "population": 1009416 }, { "name": "Sarah", "population": 1006934 }, { "name": "Betty", "population": 985364 }, { "name": "Nancy", "population": 984185 }, { "name": "Karen", "population": 982192 }, { "name": "Jeffrey", "population": 969093 }, { "name": "Lisa", "population": 962981 }, { "name": "Ryan", "population": 907969 }, { "name": "Gary", "population": 896637 }, { "name": "Helen", "population": 895428 }, { "name": "Sandra", "population": 870958 }, { "name": "Nicholas", "population": 867231 }, { "name": "Eric", "population": 862204 }, { "name": "Jacob", "population": 848518 }, { "name": "Stephen", "population": 844930 }, { "name": "Ashley", "population": 841427 }, { "name": "Donna", "population": 826714 }, { "name": "Kimberly", "population": 826275 }, { "name": "Frank", "population": 818197 }, { "name": "Carol", "population": 817290 }, { "name": "Jonathan", "population": 803723 }, { "name": "Michelle", "population": 803162 }, { "name": "Larry", "population": 801398 }, { "name": "Emily", "population": 779755 }, { "name": "Amanda", "population": 769292 }, { "name": "Scott", "population": 765844 }, { "name": "Justin", "population": 757273 }, { "name": "Laura", "population": 745892 }, { "name": "Melissa", "population": 745498 }, { "name": "Raymond", "population": 744284 }, { "name": "Deborah", "population": 735869 }, { "name": "Brandon", "population": 735849 }, { "name": "Stephanie", "population": 732651 }, { "name": "Rebecca", "population": 728799 }, { "name": "Ruth", "population": 728678 }, { "name": "Anna", "population": 719803 }, { "name": "Sharon", "population": 718701 }, { "name": "Kathleen", "population": 703265 }, { "name": "Cynthia", "population": 703175 }, { "name": "Gregory", "population": 701504 }, { "name": "Shirley", "population": 686079 }, { "name": "Samuel", "population": 681358 }, { "name": "Amy", "population": 673234 }, { "name": "Benjamin", "population": 664328 }, { "name": "Patrick", "population": 655434 }, { "name": "Angela", "population": 653663 }, { "name": "Jack", "population": 634113 }, { "name": "Virginia", "population": 621448 }, { "name": "Jerry", "population": 618105 }, { "name": "Dennis", "population": 610894 }, { "name": "Catherine", "population": 606029 }, { "name": "Brenda", "population": 604067 }, { "name": "Alexander", "population": 598944 }, { "name": "Katherine", "population": 593220 }, { "name": "Pamela", "population": 591307 }, { "name": "Nicole", "population": 576870 }, { "name": "Tyler", "population": 576031 }, { "name": "Christine", "population": 574120 }, { "name": "Henry", "population": 571539 }, { "name": "Walter", "population": 558026 }, { "name": "Peter", "population": 553789 }, { "name": "Douglas", "population": 552666 }, { "name": "Janet", "population": 550557 } ]
SELECT base.name as name, COALESCE(SUM(base.number),0) as population FROM `bigquery-public-data.usa_names.usa_1910_2013` as base GROUP BY 1 ORDER BY 2 desc
Malloy compiles to SQL. The SQL query for the above command is.
SELECT base.name as name, SUM(base.number) as population FROM `bigquery-public-data.usa_names.usa_1910_2013` as base GROUP BY 1 ORDER BY 2 desc
Expressions
Expressions work much the same as they do in SQL. We can look at population over decade by using a calculation against the year.
query: table('bigquery-public-data.usa_names.usa_1910_2013') -> { top: 10 group_by: decade is floor(`year` / 10) * 10 aggregate: population is sum(`number`) }
| decade | population |
|---|---|
| 1,950 | 37,545,138 |
| 1,960 | 35,405,002 |
| 1,990 | 33,309,594 |
| 2,000 | 33,041,629 |
| 1,980 | 32,349,146 |
| 1,970 | 29,238,092 |
| 1,940 | 27,776,913 |
| 1,920 | 21,375,400 |
| 1,930 | 19,782,373 |
| 1,910 | 13,592,350 |
[ { "decade": 1950, "population": 37545138 }, { "decade": 1960, "population": 35405002 }, { "decade": 1990, "population": 33309594 }, { "decade": 2000, "population": 33041629 }, { "decade": 1980, "population": 32349146 }, { "decade": 1970, "population": 29238092 }, { "decade": 1940, "population": 27776913 }, { "decade": 1920, "population": 21375400 }, { "decade": 1930, "population": 19782373 }, { "decade": 1910, "population": 13592350 } ]
SELECT (floor(base.year/10))*10 as decade, COALESCE(SUM(base.number),0) as population FROM `bigquery-public-data.usa_names.usa_1910_2013` as base GROUP BY 1 ORDER BY 2 desc LIMIT 10
Cohorts
source: names is from( table('bigquery-public-data.usa_names.usa_1910_2013') -> { group_by: decade is floor(`year` / 10) * 10 state gender aggregate: cohort_population is `number`.sum() nest: by_name is { group_by: name aggregate: population is `number`.sum() } } ) { measure: births_per_100k is floor(by_name.population.sum() / cohort_population.sum() * 100000) measure: total_cohort_population is cohort_population.sum() dimension: name is concat(by_name.name, '') } query: names -> { group_by: state gender aggregate: total_cohort_population nest: names is { where: name ? 'Michael' | 'Lloyd' | 'Olivia' group_by: name aggregate: population is by_name.population.sum() group_by: births_per_100k } }
| state | gender | total_​cohort_​population | names | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CA | M | 15,011,405 |
| ||||||||||||
| CA | F | 13,799,158 |
| ||||||||||||
| NY | M | 12,203,961 |
| ||||||||||||
| NY | F | 11,490,175 |
| ||||||||||||
| TX | M | 11,126,246 |
| ||||||||||||
| TX | F | 10,341,113 |
| ||||||||||||
| PA | M | 8,497,961 |
| ||||||||||||
| PA | F | 8,163,949 |
| ||||||||||||
| IL | M | 7,845,252 |
| ||||||||||||
| IL | F | 7,333,624 |
| ||||||||||||
| OH | M | 7,324,810 |
| ||||||||||||
| OH | F | 6,876,716 |
| ||||||||||||
| MI | M | 6,036,661 |
| ||||||||||||
| MI | F | 5,606,794 |
| ||||||||||||
| FL | M | 4,910,950 |
| ||||||||||||
| FL | F | 4,366,273 |
| ||||||||||||
| NC | M | 4,326,810 |
| ||||||||||||
| NJ | M | 4,315,822 |
| ||||||||||||
| GA | M | 4,214,825 |
| ||||||||||||
| NC | F | 4,113,425 |
|
[ { "state": "CA", "gender": "M", "total_cohort_population": 15011405, "names": [ { "name": "Michael", "population": 420127, "births_per_100k": 2798 }, { "name": "Lloyd", "population": 8380, "births_per_100k": 55 } ] }, { "state": "CA", "gender": "F", "total_cohort_population": 13799158, "names": [ { "name": "Olivia", "population": 33794, "births_per_100k": 244 }, { "name": "Michael", "population": 2428, "births_per_100k": 19 } ] }, { "state": "NY", "gender": "M", "total_cohort_population": 12203961, "names": [ { "name": "Michael", "population": 430732, "births_per_100k": 3529 }, { "name": "Lloyd", "population": 7568, "births_per_100k": 62 }, { "name": "Olivia", "population": 5, "births_per_100k": 0 } ] }, { "state": "NY", "gender": "F", "total_cohort_population": 11490175, "names": [ { "name": "Olivia", "population": 23219, "births_per_100k": 202 }, { "name": "Michael", "population": 1761, "births_per_100k": 16 } ] }, { "state": "TX", "gender": "M", "total_cohort_population": 11126246, "names": [ { "name": "Michael", "population": 223900, "births_per_100k": 2012 }, { "name": "Lloyd", "population": 8461, "births_per_100k": 76 }, { "name": "Olivia", "population": 6, "births_per_100k": 1 } ] }, { "state": "TX", "gender": "F", "total_cohort_population": 10341113, "names": [ { "name": "Olivia", "population": 25746, "births_per_100k": 248 }, { "name": "Michael", "population": 1420, "births_per_100k": 16 }, { "name": "Lloyd", "population": 15, "births_per_100k": 1 } ] }, { "state": "PA", "gender": "M", "total_cohort_population": 8497961, "names": [ { "name": "Michael", "population": 266380, "births_per_100k": 3134 }, { "name": "Lloyd", "population": 7874, "births_per_100k": 92 }, { "name": "Olivia", "population": 22, "births_per_100k": 2 } ] }, { "state": "PA", "gender": "F", "total_cohort_population": 8163949, "names": [ { "name": "Olivia", "population": 16292, "births_per_100k": 199 }, { "name": "Michael", "population": 910, "births_per_100k": 11 } ] }, { "state": "IL", "gender": "M", "total_cohort_population": 7845252, "names": [ { "name": "Michael", "population": 251741, "births_per_100k": 3208 }, { "name": "Lloyd", "population": 7207, "births_per_100k": 91 } ] }, { "state": "IL", "gender": "F", "total_cohort_population": 7333624, "names": [ { "name": "Olivia", "population": 16450, "births_per_100k": 224 }, { "name": "Michael", "population": 989, "births_per_100k": 17 } ] }, { "state": "OH", "gender": "M", "total_cohort_population": 7324810, "names": [ { "name": "Michael", "population": 225302, "births_per_100k": 3075 }, { "name": "Lloyd", "population": 6755, "births_per_100k": 92 } ] }, { "state": "OH", "gender": "F", "total_cohort_population": 6876716, "names": [ { "name": "Olivia", "population": 16787, "births_per_100k": 244 }, { "name": "Michael", "population": 969, "births_per_100k": 18 } ] }, { "state": "MI", "gender": "M", "total_cohort_population": 6036661, "names": [ { "name": "Michael", "population": 194851, "births_per_100k": 3227 }, { "name": "Lloyd", "population": 6130, "births_per_100k": 101 } ] }, { "state": "MI", "gender": "F", "total_cohort_population": 5606794, "names": [ { "name": "Olivia", "population": 13575, "births_per_100k": 242 }, { "name": "Michael", "population": 755, "births_per_100k": 17 } ] }, { "state": "FL", "gender": "M", "total_cohort_population": 4910950, "names": [ { "name": "Michael", "population": 138882, "births_per_100k": 2828 }, { "name": "Lloyd", "population": 2876, "births_per_100k": 58 } ] }, { "state": "FL", "gender": "F", "total_cohort_population": 4366273, "names": [ { "name": "Olivia", "population": 15208, "births_per_100k": 348 }, { "name": "Michael", "population": 691, "births_per_100k": 18 } ] }, { "state": "NC", "gender": "M", "total_cohort_population": 4326810, "names": [ { "name": "Michael", "population": 92414, "births_per_100k": 2135 }, { "name": "Lloyd", "population": 4367, "births_per_100k": 100 } ] }, { "state": "NJ", "gender": "M", "total_cohort_population": 4315822, "names": [ { "name": "Michael", "population": 165385, "births_per_100k": 3832 }, { "name": "Lloyd", "population": 1720, "births_per_100k": 41 } ] }, { "state": "GA", "gender": "M", "total_cohort_population": 4214825, "names": [ { "name": "Michael", "population": 87684, "births_per_100k": 2080 }, { "name": "Lloyd", "population": 2508, "births_per_100k": 59 } ] }, { "state": "NC", "gender": "F", "total_cohort_population": 4113425, "names": [ { "name": "Olivia", "population": 10671, "births_per_100k": 259 }, { "name": "Michael", "population": 416, "births_per_100k": 19 } ] } ]
WITH __stage0 AS ( SELECT group_set, CASE WHEN group_set IN (0,1) THEN (floor(base.year/10))*10 END as decade__0, CASE WHEN group_set IN (0,1) THEN base.state END as state__0, CASE WHEN group_set IN (0,1) THEN base.gender END as gender__0, CASE WHEN group_set=0 THEN COALESCE(SUM(base.number),0) END as cohort_population__0, CASE WHEN group_set=1 THEN base.name END as name__1, CASE WHEN group_set=1 THEN COALESCE(SUM(base.number),0) END as population__1 FROM `bigquery-public-data.usa_names.usa_1910_2013` as base CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,1,1))) GROUP BY 1,2,3,4,6 ) , __stage1 AS ( SELECT decade__0 as decade, state__0 as state, gender__0 as gender, ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( name__1 as name, population__1 as population ) END IGNORE NULLS ORDER BY population__1 desc ) as by_name FROM __stage0 GROUP BY 1,2,3 ORDER BY 4 desc ) , __stage2 AS ( SELECT group_set, CASE WHEN group_set IN (0,1) THEN names.state END as state__0, CASE WHEN group_set IN (0,1) THEN names.gender END as gender__0, CASE WHEN group_set=0 THEN COALESCE(CAST(( ( SUM(DISTINCT (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) + (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001 )) - SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001) )/(1*1.0)) as FLOAT64),0) END as total_cohort_population__0, CASE WHEN group_set=1 THEN concat(by_name_0.name,'') END as name__1, CASE WHEN group_set=1 THEN COALESCE(SUM(by_name_0.population),0) END as population__1, floor(CASE WHEN group_set=1 THEN COALESCE(SUM(by_name_0.population),0) END/CASE WHEN group_set=1 THEN COALESCE(CAST(( ( SUM(DISTINCT (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) + (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001 )) - SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001) )/(1*1.0)) as FLOAT64),0) END*100000) as births_per_100k__1 FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1 as x) as names LEFT JOIN UNNEST(names.by_name) as by_name_0 CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,1,1))) WHERE (group_set NOT IN (1) OR (group_set IN (1) AND ((concat(by_name_0.name,''))='Michael')or(((concat(by_name_0.name,''))='Lloyd')or((concat(by_name_0.name,''))='Olivia')))) GROUP BY 1,2,3,5 ) SELECT state__0 as state, gender__0 as gender, ANY_VALUE(CASE WHEN group_set=0 THEN total_cohort_population__0 END) as total_cohort_population, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( name__1 as name, population__1 as population, births_per_100k__1 as births_per_100k ) END IGNORE NULLS ORDER BY population__1 desc ) as names FROM __stage2 GROUP BY 1,2 ORDER BY 3 desc
Dashboard
query: names -> name_dashboard { where: name ~ 'Mich%' }| name | total_​population | state_​map | decade_​graph |
|---|---|---|---|
| Michael | 4,396,482 | ||
| Michelle | 813,655 | ||
| Michele | 221,811 | ||
| Micheal | 150,977 | ||
| Michaela | 48,892 | ||
| Michel | 7,062 | ||
| Michell | 4,377 | ||
| Michal | 2,402 | ||
| Michale | 954 | ||
| Michelina | 909 | ||
| Michaella | 711 | ||
| Michela | 621 | ||
| Michaelangelo | 579 | ||
| Michaelene | 477 | ||
| Michala | 465 |
[ { "name": "Michael", "total_population": 4396482, "state_map": [ { "state": "NY", "births_per_100k": 10019 }, { "state": "CA", "births_per_100k": 9886 }, { "state": "PA", "births_per_100k": 6181 }, { "state": "IL", "births_per_100k": 5844 }, { "state": "TX", "births_per_100k": 5340 }, { "state": "OH", "births_per_100k": 5228 }, { "state": "MI", "births_per_100k": 4513 }, { "state": "NJ", "births_per_100k": 3859 }, { "state": "FL", "births_per_100k": 3324 }, { "state": "MA", "births_per_100k": 3310 }, { "state": "IN", "births_per_100k": 2514 }, { "state": "MO", "births_per_100k": 2202 }, { "state": "WI", "births_per_100k": 2195 }, { "state": "NC", "births_per_100k": 2176 }, { "state": "GA", "births_per_100k": 2073 }, { "state": "VA", "births_per_100k": 2063 }, { "state": "MN", "births_per_100k": 1876 }, { "state": "MD", "births_per_100k": 1776 }, { "state": "TN", "births_per_100k": 1689 }, { "state": "WA", "births_per_100k": 1610 }, { "state": "CT", "births_per_100k": 1585 }, { "state": "LA", "births_per_100k": 1506 }, { "state": "KY", "births_per_100k": 1436 }, { "state": "AL", "births_per_100k": 1337 }, { "state": "IA", "births_per_100k": 1234 }, { "state": "CO", "births_per_100k": 1132 }, { "state": "OK", "births_per_100k": 1070 }, { "state": "AZ", "births_per_100k": 1064 }, { "state": "SC", "births_per_100k": 1043 }, { "state": "KS", "births_per_100k": 951 }, { "state": "OR", "births_per_100k": 918 }, { "state": "MS", "births_per_100k": 810 }, { "state": "WV", "births_per_100k": 787 }, { "state": "AR", "births_per_100k": 738 }, { "state": "NE", "births_per_100k": 694 }, { "state": "DC", "births_per_100k": 674 }, { "state": "UT", "births_per_100k": 669 }, { "state": "RI", "births_per_100k": 570 }, { "state": "NM", "births_per_100k": 513 }, { "state": "ME", "births_per_100k": 478 }, { "state": "NH", "births_per_100k": 380 }, { "state": "ID", "births_per_100k": 344 }, { "state": "NV", "births_per_100k": 326 }, { "state": "HI", "births_per_100k": 317 }, { "state": "MT", "births_per_100k": 299 }, { "state": "SD", "births_per_100k": 294 }, { "state": "DE", "births_per_100k": 292 }, { "state": "ND", "births_per_100k": 279 }, { "state": "VT", "births_per_100k": 206 }, { "state": "AK", "births_per_100k": 188 }, { "state": "WY", "births_per_100k": 164 } ], "decade_graph": [ { "decade": 1910, "births_per_100k": 693, "gender": "M" }, { "decade": 1910, "births_per_100k": 0, "gender": "F" }, { "decade": 1920, "births_per_100k": 856, "gender": "M" }, { "decade": 1920, "births_per_100k": 2, "gender": "F" }, { "decade": 1930, "births_per_100k": 2, "gender": "F" }, { "decade": 1930, "births_per_100k": 1271, "gender": "M" }, { "decade": 1940, "births_per_100k": 21, "gender": "F" }, { "decade": 1940, "births_per_100k": 7654, "gender": "M" }, { "decade": 1950, "births_per_100k": 38, "gender": "F" }, { "decade": 1950, "births_per_100k": 19046, "gender": "M" }, { "decade": 1960, "births_per_100k": 72, "gender": "F" }, { "decade": 1960, "births_per_100k": 18950, "gender": "M" }, { "decade": 1970, "births_per_100k": 107, "gender": "F" }, { "decade": 1970, "births_per_100k": 16094, "gender": "M" }, { "decade": 1980, "births_per_100k": 108, "gender": "F" }, { "decade": 1980, "births_per_100k": 15099, "gender": "M" }, { "decade": 1990, "births_per_100k": 30, "gender": "F" }, { "decade": 1990, "births_per_100k": 10517, "gender": "M" }, { "decade": 2000, "births_per_100k": 7, "gender": "F" }, { "decade": 2000, "births_per_100k": 5700, "gender": "M" }, { "decade": 2010, "births_per_100k": 3295, "gender": "M" }, { "decade": 2010, "births_per_100k": 0, "gender": "F" }, { "decade": 2020, "births_per_100k": 427, "gender": "M" } ] }, { "name": "Michelle", "total_population": 813655, "state_map": [ { "state": "CA", "births_per_100k": 14069 }, { "state": "NY", "births_per_100k": 8549 }, { "state": "TX", "births_per_100k": 6012 }, { "state": "IL", "births_per_100k": 5858 }, { "state": "OH", "births_per_100k": 5434 }, { "state": "PA", "births_per_100k": 4930 }, { "state": "MI", "births_per_100k": 4880 }, { "state": "FL", "births_per_100k": 3644 }, { "state": "NJ", "births_per_100k": 3091 }, { "state": "MA", "births_per_100k": 3069 }, { "state": "IN", "births_per_100k": 2544 }, { "state": "WI", "births_per_100k": 2302 }, { "state": "MO", "births_per_100k": 2183 }, { "state": "MN", "births_per_100k": 2134 }, { "state": "VA", "births_per_100k": 1897 }, { "state": "WA", "births_per_100k": 1877 }, { "state": "MD", "births_per_100k": 1617 }, { "state": "LA", "births_per_100k": 1557 }, { "state": "NC", "births_per_100k": 1514 }, { "state": "GA", "births_per_100k": 1483 }, { "state": "CO", "births_per_100k": 1467 }, { "state": "IA", "births_per_100k": 1419 }, { "state": "AZ", "births_per_100k": 1417 }, { "state": "CT", "births_per_100k": 1264 }, { "state": "KS", "births_per_100k": 1116 }, { "state": "OR", "births_per_100k": 1096 }, { "state": "KY", "births_per_100k": 1031 }, { "state": "TN", "births_per_100k": 1027 }, { "state": "UT", "births_per_100k": 955 }, { "state": "OK", "births_per_100k": 927 }, { "state": "NE", "births_per_100k": 853 }, { "state": "AL", "births_per_100k": 716 }, { "state": "SC", "births_per_100k": 712 }, { "state": "NM", "births_per_100k": 660 }, { "state": "DC", "births_per_100k": 642 }, { "state": "WV", "births_per_100k": 607 }, { "state": "ME", "births_per_100k": 520 }, { "state": "AR", "births_per_100k": 501 }, { "state": "RI", "births_per_100k": 479 }, { "state": "HI", "births_per_100k": 446 }, { "state": "MS", "births_per_100k": 427 }, { "state": "NV", "births_per_100k": 409 }, { "state": "ID", "births_per_100k": 397 }, { "state": "NH", "births_per_100k": 369 }, { "state": "ND", "births_per_100k": 358 }, { "state": "SD", "births_per_100k": 339 }, { "state": "MT", "births_per_100k": 319 }, { "state": "DE", "births_per_100k": 262 }, { "state": "AK", "births_per_100k": 224 }, { "state": "VT", "births_per_100k": 195 }, { "state": "WY", "births_per_100k": 177 } ], "decade_graph": [ { "decade": 1920, "births_per_100k": 1, "gender": "F" }, { "decade": 1930, "births_per_100k": 12, "gender": "F" }, { "decade": 1940, "births_per_100k": 641, "gender": "F" }, { "decade": 1950, "births_per_100k": 5742, "gender": "F" }, { "decade": 1960, "births_per_100k": 25599, "gender": "F" }, { "decade": 1960, "births_per_100k": 39, "gender": "M" }, { "decade": 1970, "births_per_100k": 30620, "gender": "F" }, { "decade": 1970, "births_per_100k": 73, "gender": "M" }, { "decade": 1980, "births_per_100k": 18930, "gender": "F" }, { "decade": 1980, "births_per_100k": 48, "gender": "M" }, { "decade": 1990, "births_per_100k": 10633, "gender": "F" }, { "decade": 1990, "births_per_100k": 22, "gender": "M" }, { "decade": 2000, "births_per_100k": 5332, "gender": "F" }, { "decade": 2000, "births_per_100k": 2, "gender": "M" }, { "decade": 2010, "births_per_100k": 2098, "gender": "F" }, { "decade": 2020, "births_per_100k": 202, "gender": "F" } ] }, { "name": "Michele", "total_population": 221811, "state_map": [ { "state": "NY", "births_per_100k": 15361 }, { "state": "CA", "births_per_100k": 10490 }, { "state": "PA", "births_per_100k": 10045 }, { "state": "NJ", "births_per_100k": 7111 }, { "state": "OH", "births_per_100k": 5492 }, { "state": "IL", "births_per_100k": 5176 }, { "state": "MI", "births_per_100k": 5163 }, { "state": "MA", "births_per_100k": 3123 }, { "state": "TX", "births_per_100k": 2848 }, { "state": "MD", "births_per_100k": 2473 }, { "state": "FL", "births_per_100k": 2439 }, { "state": "IN", "births_per_100k": 2327 }, { "state": "CT", "births_per_100k": 2212 }, { "state": "WI", "births_per_100k": 2064 }, { "state": "MN", "births_per_100k": 1902 }, { "state": "MO", "births_per_100k": 1754 }, { "state": "VA", "births_per_100k": 1441 }, { "state": "WA", "births_per_100k": 1435 }, { "state": "IA", "births_per_100k": 1268 }, { "state": "LA", "births_per_100k": 1018 }, { "state": "NC", "births_per_100k": 849 }, { "state": "GA", "births_per_100k": 836 }, { "state": "KY", "births_per_100k": 808 }, { "state": "CO", "births_per_100k": 772 }, { "state": "OR", "births_per_100k": 739 }, { "state": "KS", "births_per_100k": 725 }, { "state": "AZ", "births_per_100k": 697 }, { "state": "DC", "births_per_100k": 674 }, { "state": "NE", "births_per_100k": 663 }, { "state": "WV", "births_per_100k": 573 }, { "state": "RI", "births_per_100k": 554 }, { "state": "OK", "births_per_100k": 547 }, { "state": "AL", "births_per_100k": 517 }, { "state": "HI", "births_per_100k": 498 }, { "state": "UT", "births_per_100k": 485 }, { "state": "TN", "births_per_100k": 471 }, { "state": "ME", "births_per_100k": 453 }, { "state": "SC", "births_per_100k": 430 }, { "state": "DE", "births_per_100k": 424 }, { "state": "NH", "births_per_100k": 377 }, { "state": "NM", "births_per_100k": 330 }, { "state": "SD", "births_per_100k": 320 }, { "state": "AR", "births_per_100k": 285 }, { "state": "MT", "births_per_100k": 277 }, { "state": "MS", "births_per_100k": 275 }, { "state": "ID", "births_per_100k": 265 }, { "state": "ND", "births_per_100k": 260 }, { "state": "NV", "births_per_100k": 245 }, { "state": "VT", "births_per_100k": 232 }, { "state": "AK", "births_per_100k": 135 }, { "state": "WY", "births_per_100k": 116 } ], "decade_graph": [ { "decade": 1910, "births_per_100k": 27, "gender": "M" }, { "decade": 1920, "births_per_100k": 32, "gender": "M" }, { "decade": 1920, "births_per_100k": 9, "gender": "F" }, { "decade": 1930, "births_per_100k": 54, "gender": "F" }, { "decade": 1930, "births_per_100k": 2, "gender": "M" }, { "decade": 1940, "births_per_100k": 5066, "gender": "F" }, { "decade": 1940, "births_per_100k": 2, "gender": "M" }, { "decade": 1950, "births_per_100k": 18892, "gender": "F" }, { "decade": 1950, "births_per_100k": 16, "gender": "M" }, { "decade": 1960, "births_per_100k": 39218, "gender": "F" }, { "decade": 1960, "births_per_100k": 111, "gender": "M" }, { "decade": 1970, "births_per_100k": 25487, "gender": "F" }, { "decade": 1970, "births_per_100k": 145, "gender": "M" }, { "decade": 1980, "births_per_100k": 7707, "gender": "F" }, { "decade": 1980, "births_per_100k": 73, "gender": "M" }, { "decade": 1990, "births_per_100k": 2498, "gender": "F" }, { "decade": 1990, "births_per_100k": 25, "gender": "M" }, { "decade": 2000, "births_per_100k": 547, "gender": "F" }, { "decade": 2010, "births_per_100k": 76, "gender": "F" }, { "decade": 2020, "births_per_100k": 3, "gender": "F" } ] }, { "name": "Micheal", "total_population": 150977, "state_map": [ { "state": "CA", "births_per_100k": 8076 }, { "state": "TX", "births_per_100k": 7812 }, { "state": "IL", "births_per_100k": 5302 }, { "state": "OH", "births_per_100k": 4839 }, { "state": "MI", "births_per_100k": 4507 }, { "state": "NY", "births_per_100k": 4221 }, { "state": "FL", "births_per_100k": 3682 }, { "state": "NC", "births_per_100k": 3629 }, { "state": "GA", "births_per_100k": 3453 }, { "state": "LA", "births_per_100k": 3423 }, { "state": "TN", "births_per_100k": 3367 }, { "state": "MO", "births_per_100k": 3125 }, { "state": "AL", "births_per_100k": 2891 }, { "state": "IN", "births_per_100k": 2867 }, { "state": "PA", "births_per_100k": 2818 }, { "state": "MS", "births_per_100k": 2363 }, { "state": "SC", "births_per_100k": 2208 }, { "state": "VA", "births_per_100k": 2089 }, { "state": "KY", "births_per_100k": 2086 }, { "state": "OK", "births_per_100k": 2050 }, { "state": "WA", "births_per_100k": 2007 }, { "state": "WI", "births_per_100k": 1807 }, { "state": "MN", "births_per_100k": 1765 }, { "state": "IA", "births_per_100k": 1722 }, { "state": "AR", "births_per_100k": 1548 }, { "state": "KS", "births_per_100k": 1414 }, { "state": "MD", "births_per_100k": 1292 }, { "state": "OR", "births_per_100k": 1269 }, { "state": "CO", "births_per_100k": 1249 }, { "state": "NJ", "births_per_100k": 1240 }, { "state": "WV", "births_per_100k": 1089 }, { "state": "AZ", "births_per_100k": 1076 }, { "state": "MA", "births_per_100k": 976 }, { "state": "NE", "births_per_100k": 822 }, { "state": "UT", "births_per_100k": 764 }, { "state": "NM", "births_per_100k": 759 }, { "state": "DC", "births_per_100k": 645 }, { "state": "ID", "births_per_100k": 546 }, { "state": "CT", "births_per_100k": 462 }, { "state": "SD", "births_per_100k": 460 }, { "state": "MT", "births_per_100k": 408 }, { "state": "ND", "births_per_100k": 365 }, { "state": "NV", "births_per_100k": 350 }, { "state": "ME", "births_per_100k": 292 }, { "state": "WY", "births_per_100k": 191 }, { "state": "AK", "births_per_100k": 184 }, { "state": "NH", "births_per_100k": 126 }, { "state": "RI", "births_per_100k": 111 }, { "state": "VT", "births_per_100k": 87 }, { "state": "DE", "births_per_100k": 84 }, { "state": "HI", "births_per_100k": 54 } ], "decade_graph": [ { "decade": 1910, "births_per_100k": 654, "gender": "M" }, { "decade": 1920, "births_per_100k": 712, "gender": "M" }, { "decade": 1930, "births_per_100k": 600, "gender": "M" }, { "decade": 1940, "births_per_100k": 6828, "gender": "M" }, { "decade": 1950, "births_per_100k": 27050, "gender": "M" }, { "decade": 1950, "births_per_100k": 11, "gender": "F" }, { "decade": 1960, "births_per_100k": 21131, "gender": "M" }, { "decade": 1960, "births_per_100k": 27, "gender": "F" }, { "decade": 1970, "births_per_100k": 15687, "gender": "M" }, { "decade": 1970, "births_per_100k": 82, "gender": "F" }, { "decade": 1980, "births_per_100k": 38, "gender": "F" }, { "decade": 1980, "births_per_100k": 12306, "gender": "M" }, { "decade": 1990, "births_per_100k": 8392, "gender": "M" }, { "decade": 1990, "births_per_100k": 7, "gender": "F" }, { "decade": 2000, "births_per_100k": 4601, "gender": "M" }, { "decade": 2000, "births_per_100k": 3, "gender": "F" }, { "decade": 2010, "births_per_100k": 1683, "gender": "M" }, { "decade": 2020, "births_per_100k": 178, "gender": "M" } ] }, { "name": "Michaela", "total_population": 48892, "state_map": [ { "state": "CA", "births_per_100k": 10146 }, { "state": "NY", "births_per_100k": 6354 }, { "state": "TX", "births_per_100k": 6346 }, { "state": "OH", "births_per_100k": 4612 }, { "state": "MA", "births_per_100k": 4460 }, { "state": "PA", "births_per_100k": 4203 }, { "state": "FL", "births_per_100k": 4184 }, { "state": "IL", "births_per_100k": 3749 }, { "state": "NC", "births_per_100k": 3121 }, { "state": "MI", "births_per_100k": 2861 }, { "state": "GA", "births_per_100k": 2712 }, { "state": "VA", "births_per_100k": 2681 }, { "state": "MO", "births_per_100k": 2620 }, { "state": "NE", "births_per_100k": 2491 }, { "state": "IN", "births_per_100k": 2458 }, { "state": "NJ", "births_per_100k": 2364 }, { "state": "MN", "births_per_100k": 2202 }, { "state": "WI", "births_per_100k": 2174 }, { "state": "WA", "births_per_100k": 2141 }, { "state": "TN", "births_per_100k": 2100 }, { "state": "CO", "births_per_100k": 1898 }, { "state": "MD", "births_per_100k": 1795 }, { "state": "AZ", "births_per_100k": 1716 }, { "state": "RI", "births_per_100k": 1560 }, { "state": "CT", "births_per_100k": 1527 }, { "state": "KY", "births_per_100k": 1486 }, { "state": "SC", "births_per_100k": 1413 }, { "state": "IA", "births_per_100k": 1345 }, { "state": "KS", "births_per_100k": 1306 }, { "state": "OK", "births_per_100k": 1304 }, { "state": "LA", "births_per_100k": 1200 }, { "state": "AL", "births_per_100k": 1159 }, { "state": "OR", "births_per_100k": 951 }, { "state": "AR", "births_per_100k": 783 }, { "state": "MS", "births_per_100k": 670 }, { "state": "ME", "births_per_100k": 640 }, { "state": "NM", "births_per_100k": 627 }, { "state": "UT", "births_per_100k": 593 }, { "state": "WV", "births_per_100k": 511 }, { "state": "NH", "births_per_100k": 458 }, { "state": "NV", "births_per_100k": 441 }, { "state": "SD", "births_per_100k": 390 }, { "state": "MT", "births_per_100k": 337 }, { "state": "ID", "births_per_100k": 335 }, { "state": "HI", "births_per_100k": 302 }, { "state": "VT", "births_per_100k": 300 }, { "state": "ND", "births_per_100k": 274 }, { "state": "AK", "births_per_100k": 204 }, { "state": "DC", "births_per_100k": 186 }, { "state": "DE", "births_per_100k": 163 }, { "state": "WY", "births_per_100k": 122 } ], "decade_graph": [ { "decade": 1940, "births_per_100k": 42, "gender": "F" }, { "decade": 1950, "births_per_100k": 456, "gender": "F" }, { "decade": 1960, "births_per_100k": 854, "gender": "F" }, { "decade": 1970, "births_per_100k": 1871, "gender": "F" }, { "decade": 1980, "births_per_100k": 8518, "gender": "F" }, { "decade": 1990, "births_per_100k": 47210, "gender": "F" }, { "decade": 1990, "births_per_100k": 10, "gender": "M" }, { "decade": 2000, "births_per_100k": 26343, "gender": "F" }, { "decade": 2010, "births_per_100k": 12873, "gender": "F" }, { "decade": 2020, "births_per_100k": 1818, "gender": "F" } ] }, { "name": "Michel", "total_population": 7062, "state_map": [ { "state": "CA", "births_per_100k": 25106 }, { "state": "NY", "births_per_100k": 16015 }, { "state": "TX", "births_per_100k": 11498 }, { "state": "IL", "births_per_100k": 5678 }, { "state": "FL", "births_per_100k": 5550 }, { "state": "LA", "births_per_100k": 4743 }, { "state": "OH", "births_per_100k": 4687 }, { "state": "MI", "births_per_100k": 3186 }, { "state": "MA", "births_per_100k": 2676 }, { "state": "MO", "births_per_100k": 2010 }, { "state": "PA", "births_per_100k": 1840 }, { "state": "WA", "births_per_100k": 1571 }, { "state": "IN", "births_per_100k": 1373 }, { "state": "NJ", "births_per_100k": 1274 }, { "state": "ME", "births_per_100k": 1203 }, { "state": "GA", "births_per_100k": 1161 }, { "state": "TN", "births_per_100k": 1132 }, { "state": "NH", "births_per_100k": 1047 }, { "state": "NC", "births_per_100k": 1019 }, { "state": "MS", "births_per_100k": 877 }, { "state": "OK", "births_per_100k": 665 }, { "state": "CO", "births_per_100k": 623 }, { "state": "SC", "births_per_100k": 538 }, { "state": "IA", "births_per_100k": 538 }, { "state": "VA", "births_per_100k": 523 }, { "state": "KY", "births_per_100k": 481 }, { "state": "OR", "births_per_100k": 424 }, { "state": "AR", "births_per_100k": 424 }, { "state": "AL", "births_per_100k": 396 }, { "state": "WI", "births_per_100k": 354 }, { "state": "MD", "births_per_100k": 297 }, { "state": "KS", "births_per_100k": 283 }, { "state": "MN", "births_per_100k": 269 }, { "state": "CT", "births_per_100k": 226 }, { "state": "AZ", "births_per_100k": 155 }, { "state": "ID", "births_per_100k": 70 }, { "state": "VT", "births_per_100k": 70 } ], "decade_graph": [ { "decade": 1910, "births_per_100k": 863, "gender": "M" }, { "decade": 1920, "births_per_100k": 920, "gender": "M" }, { "decade": 1930, "births_per_100k": 651, "gender": "M" }, { "decade": 1940, "births_per_100k": 5876, "gender": "M" }, { "decade": 1940, "births_per_100k": 665, "gender": "F" }, { "decade": 1950, "births_per_100k": 23945, "gender": "M" }, { "decade": 1950, "births_per_100k": 821, "gender": "F" }, { "decade": 1960, "births_per_100k": 18946, "gender": "M" }, { "decade": 1960, "births_per_100k": 3936, "gender": "F" }, { "decade": 1970, "births_per_100k": 3285, "gender": "F" }, { "decade": 1970, "births_per_100k": 10917, "gender": "M" }, { "decade": 1980, "births_per_100k": 9529, "gender": "M" }, { "decade": 1980, "births_per_100k": 2633, "gender": "F" }, { "decade": 1990, "births_per_100k": 5819, "gender": "M" }, { "decade": 1990, "births_per_100k": 3001, "gender": "F" }, { "decade": 2000, "births_per_100k": 3709, "gender": "F" }, { "decade": 2000, "births_per_100k": 3171, "gender": "M" }, { "decade": 2010, "births_per_100k": 1033, "gender": "M" }, { "decade": 2010, "births_per_100k": 198, "gender": "F" }, { "decade": 2020, "births_per_100k": 70, "gender": "M" } ] }, { "name": "Michell", "total_population": 4377, "state_map": [ { "state": "CA", "births_per_100k": 24697 }, { "state": "TX", "births_per_100k": 13159 }, { "state": "NY", "births_per_100k": 11012 }, { "state": "IL", "births_per_100k": 6054 }, { "state": "FL", "births_per_100k": 5254 }, { "state": "OH", "births_per_100k": 5026 }, { "state": "MI", "births_per_100k": 4500 }, { "state": "PA", "births_per_100k": 3586 }, { "state": "LA", "births_per_100k": 3358 }, { "state": "GA", "births_per_100k": 2832 }, { "state": "MO", "births_per_100k": 2284 }, { "state": "NJ", "births_per_100k": 1964 }, { "state": "MS", "births_per_100k": 1896 }, { "state": "IN", "births_per_100k": 1804 }, { "state": "AL", "births_per_100k": 1188 }, { "state": "OK", "births_per_100k": 1142 }, { "state": "WA", "births_per_100k": 1050 }, { "state": "MD", "births_per_100k": 913 }, { "state": "AZ", "births_per_100k": 891 }, { "state": "NC", "births_per_100k": 845 }, { "state": "CO", "births_per_100k": 799 }, { "state": "SC", "births_per_100k": 776 }, { "state": "WI", "births_per_100k": 731 }, { "state": "VA", "births_per_100k": 639 }, { "state": "KS", "births_per_100k": 616 }, { "state": "KY", "births_per_100k": 502 }, { "state": "MN", "births_per_100k": 479 }, { "state": "MA", "births_per_100k": 434 }, { "state": "AR", "births_per_100k": 411 }, { "state": "TN", "births_per_100k": 297 }, { "state": "NV", "births_per_100k": 274 }, { "state": "DC", "births_per_100k": 228 }, { "state": "OR", "births_per_100k": 228 }, { "state": "IA", "births_per_100k": 114 } ], "decade_graph": [ { "decade": 1950, "births_per_100k": 1599, "gender": "F" }, { "decade": 1960, "births_per_100k": 26273, "gender": "F" }, { "decade": 1970, "births_per_100k": 38245, "gender": "F" }, { "decade": 1970, "births_per_100k": 114, "gender": "M" }, { "decade": 1980, "births_per_100k": 13319, "gender": "F" }, { "decade": 1990, "births_per_100k": 9047, "gender": "F" }, { "decade": 1990, "births_per_100k": 251, "gender": "M" }, { "decade": 2000, "births_per_100k": 10052, "gender": "F" }, { "decade": 2010, "births_per_100k": 1096, "gender": "F" } ] }, { "name": "Michal", "total_population": 2402, "state_map": [ { "state": "NY", "births_per_100k": 39175 }, { "state": "IL", "births_per_100k": 19983 }, { "state": "CA", "births_per_100k": 18692 }, { "state": "NJ", "births_per_100k": 7160 }, { "state": "TX", "births_per_100k": 6952 }, { "state": "OH", "births_per_100k": 2081 }, { "state": "PA", "births_per_100k": 1623 }, { "state": "FL", "births_per_100k": 1082 }, { "state": "MD", "births_per_100k": 666 }, { "state": "MI", "births_per_100k": 457 }, { "state": "CT", "births_per_100k": 416 }, { "state": "UT", "births_per_100k": 249 }, { "state": "AL", "births_per_100k": 208 }, { "state": "TN", "births_per_100k": 208 }, { "state": "CO", "births_per_100k": 208 }, { "state": "IA", "births_per_100k": 208 }, { "state": "GA", "births_per_100k": 208 }, { "state": "MA", "births_per_100k": 208 }, { "state": "MO", "births_per_100k": 208 } ], "decade_graph": [ { "decade": 1940, "births_per_100k": 3455, "gender": "F" }, { "decade": 1940, "births_per_100k": 208, "gender": "M" }, { "decade": 1950, "births_per_100k": 4329, "gender": "M" }, { "decade": 1950, "births_per_100k": 1790, "gender": "F" }, { "decade": 1960, "births_per_100k": 1124, "gender": "F" }, { "decade": 1960, "births_per_100k": 2206, "gender": "M" }, { "decade": 1970, "births_per_100k": 6452, "gender": "F" }, { "decade": 1970, "births_per_100k": 1457, "gender": "M" }, { "decade": 1980, "births_per_100k": 11656, "gender": "F" }, { "decade": 1980, "births_per_100k": 5495, "gender": "M" }, { "decade": 1990, "births_per_100k": 10324, "gender": "F" }, { "decade": 1990, "births_per_100k": 12947, "gender": "M" }, { "decade": 2000, "births_per_100k": 13488, "gender": "M" }, { "decade": 2000, "births_per_100k": 8617, "gender": "F" }, { "decade": 2010, "births_per_100k": 9825, "gender": "F" }, { "decade": 2010, "births_per_100k": 4288, "gender": "M" }, { "decade": 2020, "births_per_100k": 1831, "gender": "F" }, { "decade": 2020, "births_per_100k": 499, "gender": "M" } ] }, { "name": "Michale", "total_population": 954, "state_map": [ { "state": "CA", "births_per_100k": 38259 }, { "state": "TX", "births_per_100k": 17085 }, { "state": "NY", "births_per_100k": 12159 }, { "state": "IL", "births_per_100k": 7966 }, { "state": "OH", "births_per_100k": 6394 }, { "state": "FL", "births_per_100k": 4821 }, { "state": "MI", "births_per_100k": 3773 }, { "state": "GA", "births_per_100k": 1991 }, { "state": "PA", "births_per_100k": 1677 }, { "state": "IN", "births_per_100k": 1572 }, { "state": "VA", "births_per_100k": 1048 }, { "state": "KY", "births_per_100k": 628 }, { "state": "TN", "births_per_100k": 524 }, { "state": "NC", "births_per_100k": 524 }, { "state": "OK", "births_per_100k": 524 }, { "state": "AZ", "births_per_100k": 524 }, { "state": "UT", "births_per_100k": 524 } ], "decade_graph": [ { "decade": 1950, "births_per_100k": 19182, "gender": "M" }, { "decade": 1960, "births_per_100k": 16771, "gender": "M" }, { "decade": 1970, "births_per_100k": 26834, "gender": "M" }, { "decade": 1980, "births_per_100k": 31761, "gender": "M" }, { "decade": 1990, "births_per_100k": 4821, "gender": "M" }, { "decade": 2010, "births_per_100k": 628, "gender": "M" } ] }, { "name": "Michelina", "total_population": 909, "state_map": [ { "state": "NY", "births_per_100k": 71177 }, { "state": "NJ", "births_per_100k": 10011 }, { "state": "MA", "births_per_100k": 8250 }, { "state": "PA", "births_per_100k": 7040 }, { "state": "CT", "births_per_100k": 2420 }, { "state": "IL", "births_per_100k": 550 }, { "state": "RI", "births_per_100k": 550 } ], "decade_graph": [ { "decade": 1910, "births_per_100k": 23212, "gender": "F" }, { "decade": 1920, "births_per_100k": 37073, "gender": "F" }, { "decade": 1930, "births_per_100k": 19691, "gender": "F" }, { "decade": 1940, "births_per_100k": 9460, "gender": "F" }, { "decade": 1950, "births_per_100k": 3410, "gender": "F" }, { "decade": 1960, "births_per_100k": 2750, "gender": "F" }, { "decade": 1970, "births_per_100k": 1980, "gender": "F" }, { "decade": 1990, "births_per_100k": 660, "gender": "F" }, { "decade": 2000, "births_per_100k": 550, "gender": "F" }, { "decade": 2010, "births_per_100k": 550, "gender": "F" }, { "decade": 2020, "births_per_100k": 660, "gender": "F" } ] }, { "name": "Michaella", "total_population": 711, "state_map": [ { "state": "CA", "births_per_100k": 27566 }, { "state": "FL", "births_per_100k": 14486 }, { "state": "NY", "births_per_100k": 14345 }, { "state": "TX", "births_per_100k": 8438 }, { "state": "OH", "births_per_100k": 6469 }, { "state": "MA", "births_per_100k": 5344 }, { "state": "IL", "births_per_100k": 4219 }, { "state": "MI", "births_per_100k": 3656 }, { "state": "PA", "births_per_100k": 3516 }, { "state": "MO", "births_per_100k": 2672 }, { "state": "WA", "births_per_100k": 2109 }, { "state": "NC", "births_per_100k": 1687 }, { "state": "NJ", "births_per_100k": 1547 }, { "state": "IN", "births_per_100k": 1547 }, { "state": "CO", "births_per_100k": 984 }, { "state": "UT", "births_per_100k": 703 }, { "state": "GA", "births_per_100k": 703 } ], "decade_graph": [ { "decade": 1960, "births_per_100k": 703, "gender": "F" }, { "decade": 1980, "births_per_100k": 2109, "gender": "F" }, { "decade": 1990, "births_per_100k": 62869, "gender": "F" }, { "decade": 2000, "births_per_100k": 23909, "gender": "F" }, { "decade": 2010, "births_per_100k": 9563, "gender": "F" }, { "decade": 2020, "births_per_100k": 843, "gender": "F" } ] }, { "name": "Michela", "total_population": 621, "state_map": [ { "state": "NY", "births_per_100k": 31723 }, { "state": "CA", "births_per_100k": 29468 }, { "state": "MA", "births_per_100k": 20289 }, { "state": "FL", "births_per_100k": 5152 }, { "state": "NJ", "births_per_100k": 4186 }, { "state": "PA", "births_per_100k": 3864 }, { "state": "OH", "births_per_100k": 2898 }, { "state": "IL", "births_per_100k": 2415 } ], "decade_graph": [ { "decade": 1940, "births_per_100k": 805, "gender": "F" }, { "decade": 1970, "births_per_100k": 3703, "gender": "F" }, { "decade": 1980, "births_per_100k": 8534, "gender": "F" }, { "decade": 1990, "births_per_100k": 53301, "gender": "F" }, { "decade": 2000, "births_per_100k": 26892, "gender": "F" }, { "decade": 2010, "births_per_100k": 5958, "gender": "F" }, { "decade": 2020, "births_per_100k": 805, "gender": "F" } ] }, { "name": "Michaelangelo", "total_population": 579, "state_map": [ { "state": "CA", "births_per_100k": 64939 }, { "state": "TX", "births_per_100k": 14335 }, { "state": "NY", "births_per_100k": 9326 }, { "state": "FL", "births_per_100k": 5699 }, { "state": "IL", "births_per_100k": 3108 }, { "state": "AZ", "births_per_100k": 1727 }, { "state": "MA", "births_per_100k": 863 } ], "decade_graph": [ { "decade": 1970, "births_per_100k": 1727, "gender": "M" }, { "decade": 1980, "births_per_100k": 6735, "gender": "M" }, { "decade": 1990, "births_per_100k": 30224, "gender": "M" }, { "decade": 2000, "births_per_100k": 27633, "gender": "M" }, { "decade": 2010, "births_per_100k": 30742, "gender": "M" }, { "decade": 2020, "births_per_100k": 2936, "gender": "M" } ] }, { "name": "Michaelene", "total_population": 477, "state_map": [ { "state": "PA", "births_per_100k": 45073 }, { "state": "IL", "births_per_100k": 34800 }, { "state": "OH", "births_per_100k": 6079 }, { "state": "MI", "births_per_100k": 5241 }, { "state": "NY", "births_per_100k": 5241 }, { "state": "NJ", "births_per_100k": 1257 }, { "state": "IA", "births_per_100k": 1257 }, { "state": "IN", "births_per_100k": 1048 } ], "decade_graph": [ { "decade": 1930, "births_per_100k": 4612, "gender": "F" }, { "decade": 1940, "births_per_100k": 44444, "gender": "F" }, { "decade": 1950, "births_per_100k": 30817, "gender": "F" }, { "decade": 1960, "births_per_100k": 15513, "gender": "F" }, { "decade": 1970, "births_per_100k": 3354, "gender": "F" }, { "decade": 1980, "births_per_100k": 1257, "gender": "F" } ] }, { "name": "Michala", "total_population": 465, "state_map": [ { "state": "TX", "births_per_100k": 13548 }, { "state": "OH", "births_per_100k": 13118 }, { "state": "PA", "births_per_100k": 10107 }, { "state": "CA", "births_per_100k": 10107 }, { "state": "NC", "births_per_100k": 8387 }, { "state": "GA", "births_per_100k": 6236 }, { "state": "MI", "births_per_100k": 4946 }, { "state": "IL", "births_per_100k": 4731 }, { "state": "VA", "births_per_100k": 4086 }, { "state": "MO", "births_per_100k": 3870 }, { "state": "NY", "births_per_100k": 3440 }, { "state": "TN", "births_per_100k": 3010 }, { "state": "FL", "births_per_100k": 2795 }, { "state": "OK", "births_per_100k": 2580 }, { "state": "NE", "births_per_100k": 2150 }, { "state": "IN", "births_per_100k": 1290 }, { "state": "MD", "births_per_100k": 1290 }, { "state": "MN", "births_per_100k": 1075 }, { "state": "WA", "births_per_100k": 1075 }, { "state": "KY", "births_per_100k": 1075 }, { "state": "LA", "births_per_100k": 1075 } ], "decade_graph": [ { "decade": 1970, "births_per_100k": 1075, "gender": "F" }, { "decade": 1980, "births_per_100k": 1075, "gender": "F" }, { "decade": 1990, "births_per_100k": 88817, "gender": "F" }, { "decade": 2000, "births_per_100k": 9032, "gender": "F" } ] } ]
WITH __stage0 AS ( SELECT group_set, __lateral_join_bag.name__0, CASE WHEN group_set=0 THEN COALESCE(SUM(names.number),0) END as total_population__0, __lateral_join_bag.state__1, floor((CASE WHEN group_set=1 THEN COALESCE(SUM(names.number),0) END)/MAX((CASE WHEN group_set=0 THEN COALESCE(SUM(names.number),0) END)) OVER (PARTITION BY __lateral_join_bag.name__0)*100000) as births_per_100k__1, CASE WHEN group_set=2 THEN (floor(names.year/10))*10 END as decade__2, __lateral_join_bag.decade__2_string, floor((CASE WHEN group_set=2 THEN COALESCE(SUM(names.number),0) END)/MAX((CASE WHEN group_set=0 THEN COALESCE(SUM(names.number),0) END)) OVER (PARTITION BY __lateral_join_bag.name__0)*100000) as births_per_100k__2, __lateral_join_bag.gender__2 FROM `bigquery-public-data.usa_names.usa_1910_current` as names CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,2,1))) LEFT JOIN UNNEST([STRUCT(CASE WHEN group_set IN (0,1,2) THEN names.name END as name__0, CASE WHEN group_set=1 THEN names.state END as state__1, CAST(CASE WHEN group_set=2 THEN (floor(names.year/10))*10 END as STRING) as decade__2_string, CASE WHEN group_set=2 THEN names.gender END as gender__2)]) as __lateral_join_bag WHERE names.name LIKE 'Mich%' GROUP BY 1,2,4,6,7,9 ) SELECT name__0 as name, ANY_VALUE(CASE WHEN group_set=0 THEN total_population__0 END) as total_population, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( state__1 as state, births_per_100k__1 as births_per_100k ) END IGNORE NULLS ORDER BY births_per_100k__1 desc ) as state_map, ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT( decade__2 as decade, births_per_100k__2 as births_per_100k, gender__2 as gender ) END IGNORE NULLS ORDER BY decade__2 asc ) as decade_graph FROM __stage0 GROUP BY 1 ORDER BY 2 desc LIMIT 15
Iconic Names by State and Gender
Calculate the births per 100K for a name in general and a name within a state. Compute and sort by a ratio to figure out relative popularity.
query: names { where: decade < 1970 } -> { group_by: name group_by: gender aggregate: births_per_100k nest: by_state is { group_by: state aggregate: births_per_100k } } -> { where: births_per_100k > 50 group_by: by_state.state nest: by_gender is { group_by: gender nest: by_name is { top: 15 order_by: popularity desc group_by: name aggregate: popularity is (by_state.births_per_100k - births_per_100k) / births_per_100k } } }
| state | by_​gender |
|---|---|
| AK | gender F gender M |
| AL | gender F gender M |
| AR | gender F gender M |
| AZ | gender F gender M |
| CA | gender F gender M |
| CO | gender F gender M |
| CT | gender F gender M |
| DC | gender F gender M |
| DE | gender F gender M |
| FL | gender F gender M |
| GA | gender F gender M |
| HI | gender F gender M |
| IA | gender F gender M |
| ID | gender F gender M |
| IL | gender F gender M |
| IN | gender F gender M |
| KS | gender F gender M |
| KY | gender F gender M |
| LA | gender F gender M |
| MA | gender F gender M |
| MD | gender F gender M |
| ME | gender F gender M |
| MI | gender F gender M |
| MN | gender F gender M |
| MO | gender F gender M |
| MS | gender F gender M |
| MT | gender F gender M |
| NC | gender F gender M |
| ND | gender F gender M |
| NE | gender F gender M |
| NH | gender F gender M |
| NJ | gender F gender M |
| NM | gender F gender M |
| NV | gender F gender M |
| NY | gender F gender M |
| OH | gender F gender M |
| OK | gender F gender M |
| OR | gender F gender M |
| PA | gender F gender M |
| RI | gender F gender M |
| SC | gender F gender M |
| SD | gender F gender M |
| TN | gender F gender M |
| TX | gender F gender M |
| UT | gender F gender M |
| VA | gender F gender M |
| VT | gender F gender M |
| WA | gender F gender M |
| WI | gender F gender M |
| WV | gender F gender M |
| WY | gender F gender M |
[ { "state": "AK", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Lucy", "popularity": 2.96875 }, { "name": "Colleen", "popularity": 2.0625 }, { "name": "Agnes", "popularity": 2.013888888888889 }, { "name": "Christina", "popularity": 1.875 }, { "name": "Carla", "popularity": 1.6964285714285714 }, { "name": "Terry", "popularity": 1.6727272727272726 }, { "name": "Laurie", "popularity": 1.308641975308642 }, { "name": "Kelly", "popularity": 1.3043478260869565 }, { "name": "Leslie", "popularity": 1.3013698630136987 }, { "name": "Terri", "popularity": 1.2602739726027397 }, { "name": "Carrie", "popularity": 1.2205882352941178 }, { "name": "Renee", "popularity": 1.15625 }, { "name": "Tracy", "popularity": 1.0675675675675675 }, { "name": "Valerie", "popularity": 0.9146341463414634 }, { "name": "Vicki", "popularity": 0.8160919540229885 } ] }, { "gender": "M", "by_name": [ { "name": "Micheal", "popularity": 2.581818181818182 }, { "name": "Chris", "popularity": 1.88135593220339 }, { "name": "Bryan", "popularity": 1.7450980392156863 }, { "name": "Jonathan", "popularity": 1.5660377358490567 }, { "name": "Duane", "popularity": 1.206896551724138 }, { "name": "Troy", "popularity": 1.1964285714285714 }, { "name": "Jon", "popularity": 1.0158730158730158 }, { "name": "Dan", "popularity": 0.8928571428571429 }, { "name": "Glen", "popularity": 0.890625 }, { "name": "Arnold", "popularity": 0.875 }, { "name": "Bradley", "popularity": 0.7592592592592593 }, { "name": "Jeffery", "popularity": 0.7590361445783133 }, { "name": "Jay", "popularity": 0.7402597402597403 }, { "name": "Mike", "popularity": 0.7105263157894737 }, { "name": "Joel", "popularity": 0.6271186440677966 } ] } ] }, { "state": "AL", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Mattie", "popularity": 259.75471698113205 }, { "name": "Willie", "popularity": 183.9090909090909 }, { "name": "Minnie", "popularity": 163.58928571428572 }, { "name": "Lillie", "popularity": 152.06153846153848 }, { "name": "Bessie", "popularity": 112.03076923076924 }, { "name": "Jessie", "popularity": 111.35483870967742 }, { "name": "Nellie", "popularity": 102.08333333333333 }, { "name": "Glenda", "popularity": 99.96774193548387 }, { "name": "Carrie", "popularity": 90.32352941176471 }, { "name": "Annie", "popularity": 89.64935064935065 }, { "name": "Myrtle", "popularity": 88.8 }, { "name": "Gwendolyn", "popularity": 87.12068965517241 }, { "name": "Ella", "popularity": 86.53731343283582 }, { "name": "Billie", "popularity": 83.49019607843137 }, { "name": "Rosa", "popularity": 77.78787878787878 } ] }, { "gender": "M", "by_name": [ { "name": "Johnnie", "popularity": 165.8846153846154 }, { "name": "Charlie", "popularity": 145.7462686567164 }, { "name": "Jimmie", "popularity": 129.06666666666666 }, { "name": "Cecil", "popularity": 106.39285714285714 }, { "name": "Sam", "popularity": 97.63461538461539 }, { "name": "Eddie", "popularity": 76.30927835051547 }, { "name": "Tommy", "popularity": 67.95121951219512 }, { "name": "Milton", "popularity": 59.2 }, { "name": "Herman", "popularity": 58.22857142857143 }, { "name": "Jesse", "popularity": 55.69047619047619 }, { "name": "Calvin", "popularity": 55.445945945945944 }, { "name": "Franklin", "popularity": 55.442622950819676 }, { "name": "Leon", "popularity": 54.57692307692308 }, { "name": "Micheal", "popularity": 54.43636363636364 }, { "name": "Willie", "popularity": 53.95614035087719 } ] } ] }, { "state": "AR", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Billie", "popularity": 99.3921568627451 }, { "name": "Mattie", "popularity": 80.33962264150944 }, { "name": "Patsy", "popularity": 72.55555555555556 }, { "name": "Willie", "popularity": 70.66233766233766 }, { "name": "Jessie", "popularity": 65.5 }, { "name": "Glenda", "popularity": 64.2258064516129 }, { "name": "Minnie", "popularity": 62.839285714285715 }, { "name": "Lillie", "popularity": 61.707692307692305 }, { "name": "Myrtle", "popularity": 53.527272727272724 }, { "name": "Margie", "popularity": 50.79032258064516 }, { "name": "Georgia", "popularity": 50.77272727272727 }, { "name": "Bessie", "popularity": 48.84615384615385 }, { "name": "Alma", "popularity": 46.878787878787875 }, { "name": "Maxine", "popularity": 46.171875 }, { "name": "Wilma", "popularity": 44.13253012048193 } ] }, { "gender": "M", "by_name": [ { "name": "Jimmie", "popularity": 75.83333333333333 }, { "name": "Johnnie", "popularity": 72.36538461538461 }, { "name": "Cecil", "popularity": 66.71428571428571 }, { "name": "Tommy", "popularity": 55.18292682926829 }, { "name": "Troy", "popularity": 53.82142857142857 }, { "name": "Charlie", "popularity": 44.1044776119403 }, { "name": "Sam", "popularity": 43.25 }, { "name": "Herman", "popularity": 40.65714285714286 }, { "name": "Floyd", "popularity": 40.073170731707314 }, { "name": "Calvin", "popularity": 40.054054054054056 }, { "name": "Jimmy", "popularity": 39.365671641791046 }, { "name": "Chester", "popularity": 37.28125 }, { "name": "Eddie", "popularity": 36.5360824742268 }, { "name": "Ronnie", "popularity": 35.67816091954023 }, { "name": "Wesley", "popularity": 34.92156862745098 } ] } ] }, { "state": "AZ", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Christina", "popularity": 24.696428571428573 }, { "name": "Rachel", "popularity": 21.152542372881356 }, { "name": "Nellie", "popularity": 20.616666666666667 }, { "name": "Lucy", "popularity": 19.609375 }, { "name": "Rosa", "popularity": 18.696969696969695 }, { "name": "Stella", "popularity": 18.526315789473685 }, { "name": "Terry", "popularity": 17.963636363636365 }, { "name": "Maria", "popularity": 15.896103896103897 }, { "name": "Jessie", "popularity": 12.709677419354838 }, { "name": "Billie", "popularity": 11.372549019607844 }, { "name": "Margie", "popularity": 11.32258064516129 }, { "name": "Victoria", "popularity": 11.209302325581396 }, { "name": "Carla", "popularity": 10.857142857142858 }, { "name": "Terri", "popularity": 10.67123287671233 }, { "name": "Charlene", "popularity": 10.136363636363637 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 121.98039215686275 }, { "name": "Jose", "popularity": 46.23376623376623 }, { "name": "Gilbert", "popularity": 42.278688524590166 }, { "name": "Dan", "popularity": 19.089285714285715 }, { "name": "Arnold", "popularity": 17.625 }, { "name": "Bryan", "popularity": 16.03921568627451 }, { "name": "Bob", "popularity": 15.854545454545455 }, { "name": "Chris", "popularity": 15.711864406779661 }, { "name": "Sam", "popularity": 15.711538461538462 }, { "name": "Tom", "popularity": 14.813333333333333 }, { "name": "Tony", "popularity": 14.656565656565656 }, { "name": "Jimmie", "popularity": 14.333333333333334 }, { "name": "Troy", "popularity": 13.357142857142858 }, { "name": "Jonathan", "popularity": 13.132075471698114 }, { "name": "Micheal", "popularity": 12.818181818181818 } ] } ] }, { "state": "CA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Christina", "popularity": 275.23214285714283 }, { "name": "Terry", "popularity": 197.21818181818182 }, { "name": "Leslie", "popularity": 175.6986301369863 }, { "name": "Renee", "popularity": 171.171875 }, { "name": "Rachel", "popularity": 155.27118644067798 }, { "name": "Terri", "popularity": 152.0958904109589 }, { "name": "Carla", "popularity": 144.44642857142858 }, { "name": "Tracy", "popularity": 143.32432432432432 }, { "name": "Andrea", "popularity": 141.6231884057971 }, { "name": "Colleen", "popularity": 141.515625 }, { "name": "Laurie", "popularity": 135.1358024691358 }, { "name": "Victoria", "popularity": 132.98837209302326 }, { "name": "Yvonne", "popularity": 131.62337662337663 }, { "name": "Joy", "popularity": 131.16981132075472 }, { "name": "Valerie", "popularity": 129.90243902439025 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 452.3529411764706 }, { "name": "Bob", "popularity": 243.74545454545455 }, { "name": "Chris", "popularity": 214 }, { "name": "Jose", "popularity": 210.42857142857142 }, { "name": "Gilbert", "popularity": 209.4262295081967 }, { "name": "Jeff", "popularity": 194.43548387096774 }, { "name": "Bryan", "popularity": 194.01960784313727 }, { "name": "Dan", "popularity": 191.58928571428572 }, { "name": "Jon", "popularity": 191.015873015873 }, { "name": "Jonathan", "popularity": 159.67924528301887 }, { "name": "Bradley", "popularity": 159.11111111111111 }, { "name": "Jim", "popularity": 155.8095238095238 }, { "name": "Tom", "popularity": 151.14666666666668 }, { "name": "Micheal", "popularity": 144.27272727272728 }, { "name": "Wesley", "popularity": 129.98039215686273 } ] } ] }, { "state": "CO", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Carla", "popularity": 24.25 }, { "name": "Leona", "popularity": 23.153846153846153 }, { "name": "Christina", "popularity": 22.232142857142858 }, { "name": "Stella", "popularity": 21.63157894736842 }, { "name": "Maxine", "popularity": 21.296875 }, { "name": "Viola", "popularity": 20.934426229508198 }, { "name": "Terry", "popularity": 20.70909090909091 }, { "name": "Kay", "popularity": 19.94736842105263 }, { "name": "Charlene", "popularity": 18.924242424242426 }, { "name": "Terri", "popularity": 18.47945205479452 }, { "name": "Billie", "popularity": 17.705882352941178 }, { "name": "Leslie", "popularity": 17.383561643835616 }, { "name": "Renee", "popularity": 17.046875 }, { "name": "Lucy", "popularity": 16.96875 }, { "name": "Joy", "popularity": 16.943396226415093 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 50.23529411764706 }, { "name": "Bob", "popularity": 36.8 }, { "name": "Gilbert", "popularity": 35.131147540983605 }, { "name": "Dan", "popularity": 29.5 }, { "name": "Chris", "popularity": 28.694915254237287 }, { "name": "Troy", "popularity": 26.75 }, { "name": "Duane", "popularity": 26.224137931034484 }, { "name": "Sam", "popularity": 25.73076923076923 }, { "name": "Bradley", "popularity": 25.185185185185187 }, { "name": "Glen", "popularity": 23.46875 }, { "name": "Bryan", "popularity": 22.431372549019606 }, { "name": "Wesley", "popularity": 22.41176470588235 }, { "name": "Tom", "popularity": 21.76 }, { "name": "Jim", "popularity": 20.857142857142858 }, { "name": "Leslie", "popularity": 20.75862068965517 } ] } ] }, { "state": "CT", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maureen", "popularity": 42.3421052631579 }, { "name": "Lucy", "popularity": 31.40625 }, { "name": "Laurie", "popularity": 30.62962962962963 }, { "name": "Lynn", "popularity": 27.79381443298969 }, { "name": "Stella", "popularity": 27.157894736842106 }, { "name": "Emily", "popularity": 27.11111111111111 }, { "name": "Marion", "popularity": 27.02970297029703 }, { "name": "Andrea", "popularity": 26.942028985507246 }, { "name": "Michele", "popularity": 24.57777777777778 }, { "name": "Beth", "popularity": 24.304347826086957 }, { "name": "Wendy", "popularity": 23.97752808988764 }, { "name": "Leslie", "popularity": 23.698630136986303 }, { "name": "Carole", "popularity": 21.238805970149254 }, { "name": "Gertrude", "popularity": 21.22077922077922 }, { "name": "Marcia", "popularity": 21.18918918918919 } ] }, { "gender": "M", "by_name": [ { "name": "Nicholas", "popularity": 63.813559322033896 }, { "name": "Jonathan", "popularity": 54.37735849056604 }, { "name": "Vincent", "popularity": 24.254545454545454 }, { "name": "Theodore", "popularity": 21.846938775510203 }, { "name": "Chester", "popularity": 21.328125 }, { "name": "Frederick", "popularity": 20.048 }, { "name": "Arnold", "popularity": 19.232142857142858 }, { "name": "Francis", "popularity": 19.126666666666665 }, { "name": "Matthew", "popularity": 17.834862385321102 }, { "name": "Peter", "popularity": 17.27391304347826 }, { "name": "Bryan", "popularity": 17.15686274509804 }, { "name": "Wesley", "popularity": 16.274509803921568 }, { "name": "Leo", "popularity": 15.975609756097562 }, { "name": "Benjamin", "popularity": 15.93421052631579 }, { "name": "Joel", "popularity": 15.830508474576272 } ] } ] }, { "state": "DC", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Gwendolyn", "popularity": 23.275862068965516 }, { "name": "Renee", "popularity": 18.78125 }, { "name": "Delores", "popularity": 18.295774647887324 }, { "name": "Leslie", "popularity": 15.424657534246576 }, { "name": "Yvonne", "popularity": 15.207792207792208 }, { "name": "Christina", "popularity": 15 }, { "name": "Regina", "popularity": 14.38888888888889 }, { "name": "Andrea", "popularity": 14.202898550724637 }, { "name": "Terry", "popularity": 13.963636363636363 }, { "name": "Marsha", "popularity": 13.053571428571429 }, { "name": "Constance", "popularity": 12.93421052631579 }, { "name": "Valerie", "popularity": 12.548780487804878 }, { "name": "Dianne", "popularity": 12.381818181818181 }, { "name": "Carla", "popularity": 12.321428571428571 }, { "name": "Carole", "popularity": 11.761194029850746 } ] }, { "gender": "M", "by_name": [ { "name": "Jonathan", "popularity": 25.50943396226415 }, { "name": "Milton", "popularity": 14.95 }, { "name": "Jerome", "popularity": 14.783783783783784 }, { "name": "Calvin", "popularity": 11.77027027027027 }, { "name": "Benjamin", "popularity": 11.289473684210526 }, { "name": "Franklin", "popularity": 11.049180327868852 }, { "name": "Bernard", "popularity": 10.813084112149532 }, { "name": "Bryan", "popularity": 10.470588235294118 }, { "name": "Leon", "popularity": 9.923076923076923 }, { "name": "Warren", "popularity": 9.724137931034482 }, { "name": "Alvin", "popularity": 9.467532467532468 }, { "name": "Micheal", "popularity": 9.2 }, { "name": "Nicholas", "popularity": 9.186440677966102 }, { "name": "Lewis", "popularity": 8.958333333333334 }, { "name": "Jon", "popularity": 8.714285714285714 } ] } ] }, { "state": "DE", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Terry", "popularity": 5.236363636363636 }, { "name": "Michele", "popularity": 3.9 }, { "name": "Andrea", "popularity": 3.5652173913043477 }, { "name": "Constance", "popularity": 3.526315789473684 }, { "name": "Regina", "popularity": 3.486111111111111 }, { "name": "Pearl", "popularity": 3.2666666666666666 }, { "name": "Valerie", "popularity": 3.1097560975609757 }, { "name": "Tracy", "popularity": 3.108108108108108 }, { "name": "Sara", "popularity": 3.1066666666666665 }, { "name": "Marian", "popularity": 2.948717948717949 }, { "name": "Carla", "popularity": 2.9107142857142856 }, { "name": "Dawn", "popularity": 2.8773584905660377 }, { "name": "Christina", "popularity": 2.7857142857142856 }, { "name": "Terri", "popularity": 2.7534246575342465 }, { "name": "Joanne", "popularity": 2.6666666666666665 } ] }, { "gender": "M", "by_name": [ { "name": "Franklin", "popularity": 6.049180327868853 }, { "name": "Jonathan", "popularity": 5.018867924528302 }, { "name": "Harvey", "popularity": 4.838709677419355 }, { "name": "Bryan", "popularity": 4.294117647058823 }, { "name": "Nicholas", "popularity": 3.847457627118644 }, { "name": "Francis", "popularity": 3.533333333333333 }, { "name": "Benjamin", "popularity": 3.3947368421052633 }, { "name": "Lewis", "popularity": 3.1944444444444446 }, { "name": "Leon", "popularity": 2.8076923076923075 }, { "name": "Jay", "popularity": 2.6363636363636362 }, { "name": "Barry", "popularity": 2.097826086956522 }, { "name": "Theodore", "popularity": 1.9591836734693877 }, { "name": "Alfred", "popularity": 1.7777777777777777 }, { "name": "Elmer", "popularity": 1.7384615384615385 }, { "name": "Chris", "popularity": 1.7118644067796611 } ] } ] }, { "state": "FL", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Gwendolyn", "popularity": 78.75862068965517 }, { "name": "Rosa", "popularity": 57.65151515151515 }, { "name": "Lillie", "popularity": 53.47692307692308 }, { "name": "Willie", "popularity": 51.74025974025974 }, { "name": "Mattie", "popularity": 49.81132075471698 }, { "name": "Minnie", "popularity": 47.892857142857146 }, { "name": "Terry", "popularity": 46.96363636363636 }, { "name": "Glenda", "popularity": 46.45161290322581 }, { "name": "Joy", "popularity": 44.0188679245283 }, { "name": "Carla", "popularity": 42.05357142857143 }, { "name": "Marsha", "popularity": 39.857142857142854 }, { "name": "Carrie", "popularity": 38.5735294117647 }, { "name": "Terri", "popularity": 36.75342465753425 }, { "name": "Tracy", "popularity": 36.5 }, { "name": "Myrtle", "popularity": 36.07272727272727 } ] }, { "gender": "M", "by_name": [ { "name": "Johnnie", "popularity": 94.67307692307692 }, { "name": "Jimmie", "popularity": 60.81666666666667 }, { "name": "Charlie", "popularity": 55.61194029850746 }, { "name": "Cecil", "popularity": 53.625 }, { "name": "Micheal", "popularity": 48.96363636363636 }, { "name": "Jonathan", "popularity": 47.056603773584904 }, { "name": "Wesley", "popularity": 45.01960784313726 }, { "name": "Troy", "popularity": 43.44642857142857 }, { "name": "Franklin", "popularity": 42.14754098360656 }, { "name": "Eddie", "popularity": 40.16494845360825 }, { "name": "Sam", "popularity": 39.92307692307692 }, { "name": "Bryan", "popularity": 39.21568627450981 }, { "name": "Benjamin", "popularity": 38.73684210526316 }, { "name": "Joel", "popularity": 37.30508474576271 }, { "name": "Calvin", "popularity": 37.027027027027025 } ] } ] }, { "state": "GA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Mattie", "popularity": 309.8867924528302 }, { "name": "Willie", "popularity": 188.9090909090909 }, { "name": "Lillie", "popularity": 164.26153846153846 }, { "name": "Minnie", "popularity": 158.46428571428572 }, { "name": "Rosa", "popularity": 137.9848484848485 }, { "name": "Sara", "popularity": 117.29333333333334 }, { "name": "Bessie", "popularity": 111.81538461538462 }, { "name": "Jessie", "popularity": 111.40322580645162 }, { "name": "Carrie", "popularity": 105.44117647058823 }, { "name": "Nellie", "popularity": 103.46666666666667 }, { "name": "Gwendolyn", "popularity": 101.62068965517241 }, { "name": "Glenda", "popularity": 99.11290322580645 }, { "name": "Annie", "popularity": 91.3896103896104 }, { "name": "Ella", "popularity": 91.17910447761194 }, { "name": "Emily", "popularity": 81.72222222222223 } ] }, { "gender": "M", "by_name": [ { "name": "Charlie", "popularity": 236.7462686567164 }, { "name": "Johnnie", "popularity": 190.3846153846154 }, { "name": "Jimmie", "popularity": 107.26666666666667 }, { "name": "Cecil", "popularity": 98.41071428571429 }, { "name": "Eddie", "popularity": 93.51546391752578 }, { "name": "Sam", "popularity": 85.65384615384616 }, { "name": "Tommy", "popularity": 83.20731707317073 }, { "name": "Franklin", "popularity": 76.37704918032787 }, { "name": "Calvin", "popularity": 75.86486486486487 }, { "name": "Lewis", "popularity": 72.95833333333333 }, { "name": "Milton", "popularity": 71.96666666666667 }, { "name": "Herman", "popularity": 68.27142857142857 }, { "name": "Willie", "popularity": 67.79385964912281 }, { "name": "Joel", "popularity": 67.54237288135593 }, { "name": "Wesley", "popularity": 67.41176470588235 } ] } ] }, { "state": "HI", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Charlene", "popularity": 13.363636363636363 }, { "name": "Joy", "popularity": 11.075471698113208 }, { "name": "Emily", "popularity": 10.74074074074074 }, { "name": "Gwendolyn", "popularity": 10.258620689655173 }, { "name": "Renee", "popularity": 9.828125 }, { "name": "Pearl", "popularity": 9.666666666666666 }, { "name": "Colleen", "popularity": 9.3125 }, { "name": "Valerie", "popularity": 8.695121951219512 }, { "name": "Agnes", "popularity": 8.625 }, { "name": "Elsie", "popularity": 8.012820512820513 }, { "name": "Yvonne", "popularity": 7.740259740259741 }, { "name": "Kay", "popularity": 6.912280701754386 }, { "name": "Wendy", "popularity": 6.887640449438202 }, { "name": "Lynn", "popularity": 6.690721649484536 }, { "name": "Amy", "popularity": 6.6571428571428575 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 23.019607843137255 }, { "name": "Wesley", "popularity": 16.862745098039216 }, { "name": "Gilbert", "popularity": 15.78688524590164 }, { "name": "Benjamin", "popularity": 14.302631578947368 }, { "name": "Leslie", "popularity": 13.89655172413793 }, { "name": "Jonathan", "popularity": 11.69811320754717 }, { "name": "Jon", "popularity": 11.412698412698413 }, { "name": "Milton", "popularity": 10.816666666666666 }, { "name": "Alvin", "popularity": 10.402597402597403 }, { "name": "Calvin", "popularity": 9.95945945945946 }, { "name": "Dean", "popularity": 9.779220779220779 }, { "name": "Bryan", "popularity": 9.72549019607843 }, { "name": "Gordon", "popularity": 8.481927710843374 }, { "name": "Edwin", "popularity": 8.309278350515465 }, { "name": "Clyde", "popularity": 7.666666666666667 } ] } ] }, { "state": "IA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maxine", "popularity": 73.40625 }, { "name": "Kay", "popularity": 62.49122807017544 }, { "name": "Leona", "popularity": 59.03846153846154 }, { "name": "Marlene", "popularity": 45.67164179104478 }, { "name": "Marcia", "popularity": 44.391891891891895 }, { "name": "Colleen", "popularity": 43.671875 }, { "name": "Delores", "popularity": 42.87323943661972 }, { "name": "Viola", "popularity": 41 }, { "name": "Carla", "popularity": 40.589285714285715 }, { "name": "Arlene", "popularity": 37.35443037974684 }, { "name": "Marsha", "popularity": 36.07142857142857 }, { "name": "Beth", "popularity": 36.04347826086956 }, { "name": "Wilma", "popularity": 35.975903614457835 }, { "name": "Joy", "popularity": 34.43396226415094 }, { "name": "Dianne", "popularity": 33.836363636363636 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 110.01724137931035 }, { "name": "Bradley", "popularity": 69.48148148148148 }, { "name": "Dean", "popularity": 68.42857142857143 }, { "name": "Bob", "popularity": 59.10909090909091 }, { "name": "Jon", "popularity": 56.38095238095238 }, { "name": "Dan", "popularity": 48.30357142857143 }, { "name": "Arnold", "popularity": 47.660714285714285 }, { "name": "Glen", "popularity": 46.234375 }, { "name": "Darrell", "popularity": 45 }, { "name": "Jeff", "popularity": 42.38709677419355 }, { "name": "Gene", "popularity": 41.36619718309859 }, { "name": "Tom", "popularity": 41.093333333333334 }, { "name": "Elmer", "popularity": 40.58461538461538 }, { "name": "Jim", "popularity": 39.773809523809526 }, { "name": "Leslie", "popularity": 39.43103448275862 } ] } ] }, { "state": "ID", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maxine", "popularity": 14.34375 }, { "name": "Colleen", "popularity": 13.09375 }, { "name": "Kay", "popularity": 12.75438596491228 }, { "name": "Joy", "popularity": 11.50943396226415 }, { "name": "Carla", "popularity": 11.410714285714286 }, { "name": "Leona", "popularity": 10.403846153846153 }, { "name": "Vickie", "popularity": 9.142857142857142 }, { "name": "Vicki", "popularity": 8.781609195402298 }, { "name": "Billie", "popularity": 8.647058823529411 }, { "name": "Marsha", "popularity": 8.303571428571429 }, { "name": "Terri", "popularity": 7.6438356164383565 }, { "name": "Marlene", "popularity": 7.343283582089552 }, { "name": "Glenda", "popularity": 7.129032258064516 }, { "name": "Terry", "popularity": 6.8 }, { "name": "Beth", "popularity": 6.63768115942029 } ] }, { "gender": "M", "by_name": [ { "name": "Bob", "popularity": 17.836363636363636 }, { "name": "Dan", "popularity": 16.410714285714285 }, { "name": "Glen", "popularity": 14.609375 }, { "name": "Bradley", "popularity": 13.88888888888889 }, { "name": "Wesley", "popularity": 13.627450980392156 }, { "name": "Dean", "popularity": 12.948051948051948 }, { "name": "Duane", "popularity": 12.879310344827585 }, { "name": "Jay", "popularity": 12.467532467532468 }, { "name": "Don", "popularity": 11.344086021505376 }, { "name": "Bryan", "popularity": 11.235294117647058 }, { "name": "Darrell", "popularity": 10.942857142857143 }, { "name": "Jim", "popularity": 10.535714285714286 }, { "name": "Leslie", "popularity": 10.431034482758621 }, { "name": "Gene", "popularity": 10.380281690140846 }, { "name": "Micheal", "popularity": 9.727272727272727 } ] } ] }, { "state": "IL", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Leona", "popularity": 121.86538461538461 }, { "name": "Marsha", "popularity": 117.89285714285714 }, { "name": "Renee", "popularity": 111.890625 }, { "name": "Carole", "popularity": 111.80597014925372 }, { "name": "Emily", "popularity": 109.01851851851852 }, { "name": "Marlene", "popularity": 107.68656716417911 }, { "name": "Carla", "popularity": 106.125 }, { "name": "Kay", "popularity": 105.82456140350877 }, { "name": "Joy", "popularity": 105.69811320754717 }, { "name": "Rosemary", "popularity": 105.34939759036145 }, { "name": "Christina", "popularity": 99.92857142857143 }, { "name": "Marcia", "popularity": 98.37837837837837 }, { "name": "Jill", "popularity": 97 }, { "name": "Colleen", "popularity": 95.328125 }, { "name": "Charlene", "popularity": 94.6969696969697 } ] }, { "gender": "M", "by_name": [ { "name": "Bradley", "popularity": 143.88888888888889 }, { "name": "Bob", "popularity": 125.85454545454546 }, { "name": "Jerome", "popularity": 119.45945945945945 }, { "name": "Sam", "popularity": 115.84615384615384 }, { "name": "Chester", "popularity": 109 }, { "name": "Micheal", "popularity": 105.69090909090909 }, { "name": "Dan", "popularity": 105.46428571428571 }, { "name": "Elmer", "popularity": 101.49230769230769 }, { "name": "Bryan", "popularity": 99.74509803921569 }, { "name": "Tom", "popularity": 98.14666666666666 }, { "name": "Leslie", "popularity": 96.3103448275862 }, { "name": "Nicholas", "popularity": 93.52542372881356 }, { "name": "Duane", "popularity": 93.15517241379311 }, { "name": "Glen", "popularity": 92.671875 }, { "name": "Arnold", "popularity": 91.73214285714286 } ] } ] }, { "state": "IN", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Marsha", "popularity": 87.19642857142857 }, { "name": "Beth", "popularity": 75.97101449275362 }, { "name": "Carla", "popularity": 68.14285714285714 }, { "name": "Christina", "popularity": 66.82142857142857 }, { "name": "Vickie", "popularity": 66.28571428571429 }, { "name": "Marcia", "popularity": 63.58108108108108 }, { "name": "Kay", "popularity": 62.45614035087719 }, { "name": "Wilma", "popularity": 62.373493975903614 }, { "name": "Sue", "popularity": 57.32941176470588 }, { "name": "Maxine", "popularity": 56.296875 }, { "name": "Joy", "popularity": 54.77358490566038 }, { "name": "Terri", "popularity": 51.986301369863014 }, { "name": "Leona", "popularity": 51.78846153846154 }, { "name": "Vicki", "popularity": 49.7816091954023 }, { "name": "Jill", "popularity": 48.54545454545455 } ] }, { "gender": "M", "by_name": [ { "name": "Bradley", "popularity": 87.33333333333333 }, { "name": "Bryan", "popularity": 70.31372549019608 }, { "name": "Bob", "popularity": 67.98181818181818 }, { "name": "Jeff", "popularity": 66.87096774193549 }, { "name": "Jon", "popularity": 65.11111111111111 }, { "name": "Micheal", "popularity": 61.29090909090909 }, { "name": "Jeffery", "popularity": 59.86746987951807 }, { "name": "Chris", "popularity": 58.3728813559322 }, { "name": "Dan", "popularity": 58.107142857142854 }, { "name": "Troy", "popularity": 57.125 }, { "name": "Glen", "popularity": 53.796875 }, { "name": "Darrell", "popularity": 52.8 }, { "name": "Duane", "popularity": 52.51724137931034 }, { "name": "Randall", "popularity": 50.747126436781606 }, { "name": "Chester", "popularity": 49.765625 } ] } ] }, { "state": "KS", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maxine", "popularity": 52.34375 }, { "name": "Leona", "popularity": 44.57692307692308 }, { "name": "Marsha", "popularity": 41.32142857142857 }, { "name": "Wilma", "popularity": 39.734939759036145 }, { "name": "Kay", "popularity": 39.10526315789474 }, { "name": "Billie", "popularity": 33.588235294117645 }, { "name": "Carla", "popularity": 33.44642857142857 }, { "name": "Vera", "popularity": 32.75 }, { "name": "Glenda", "popularity": 32.03225806451613 }, { "name": "Viola", "popularity": 28.327868852459016 }, { "name": "Vickie", "popularity": 28.126984126984127 }, { "name": "Joy", "popularity": 27 }, { "name": "Delores", "popularity": 26.6056338028169 }, { "name": "Marcia", "popularity": 24.89189189189189 }, { "name": "Terri", "popularity": 24.52054794520548 } ] }, { "gender": "M", "by_name": [ { "name": "Bob", "popularity": 53.472727272727276 }, { "name": "Duane", "popularity": 50.43103448275862 }, { "name": "Bradley", "popularity": 50.074074074074076 }, { "name": "Wesley", "popularity": 37.03921568627451 }, { "name": "Cecil", "popularity": 36.464285714285715 }, { "name": "Glen", "popularity": 36.390625 }, { "name": "Elmer", "popularity": 34.41538461538462 }, { "name": "Leslie", "popularity": 34.12068965517241 }, { "name": "Darrell", "popularity": 33.8 }, { "name": "Vernon", "popularity": 32.17948717948718 }, { "name": "Troy", "popularity": 32.160714285714285 }, { "name": "Jimmie", "popularity": 31.083333333333332 }, { "name": "Bryan", "popularity": 30.19607843137255 }, { "name": "Jon", "popularity": 29.80952380952381 }, { "name": "Dean", "popularity": 29.350649350649352 } ] } ] }, { "state": "KY", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Myrtle", "popularity": 95.67272727272727 }, { "name": "Billie", "popularity": 91.23529411764706 }, { "name": "Alma", "popularity": 77.12121212121212 }, { "name": "Nellie", "popularity": 76.65 }, { "name": "Margie", "popularity": 74.53225806451613 }, { "name": "Wilma", "popularity": 73.46987951807229 }, { "name": "Stella", "popularity": 71.78947368421052 }, { "name": "Mattie", "popularity": 71.01886792452831 }, { "name": "Minnie", "popularity": 70.94642857142857 }, { "name": "Bessie", "popularity": 68.6 }, { "name": "Georgia", "popularity": 66.62121212121212 }, { "name": "Vickie", "popularity": 62.92063492063492 }, { "name": "Patsy", "popularity": 59.958333333333336 }, { "name": "Lucy", "popularity": 58.921875 }, { "name": "Ella", "popularity": 58.6865671641791 } ] }, { "gender": "M", "by_name": [ { "name": "Cecil", "popularity": 102.98214285714286 }, { "name": "Chester", "popularity": 75.734375 }, { "name": "Elmer", "popularity": 74.72307692307692 }, { "name": "Arnold", "popularity": 63.75 }, { "name": "Jimmie", "popularity": 63.11666666666667 }, { "name": "Darrell", "popularity": 60.32857142857143 }, { "name": "Ronnie", "popularity": 57.94252873563219 }, { "name": "Troy", "popularity": 57.339285714285715 }, { "name": "Clyde", "popularity": 55.266666666666666 }, { "name": "Leslie", "popularity": 53.258620689655174 }, { "name": "Franklin", "popularity": 52.01639344262295 }, { "name": "Johnnie", "popularity": 51.07692307692308 }, { "name": "Herman", "popularity": 46.285714285714285 }, { "name": "Jesse", "popularity": 45.166666666666664 }, { "name": "Glen", "popularity": 43.59375 } ] } ] }, { "state": "LA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Gwendolyn", "popularity": 93.24137931034483 }, { "name": "Lillie", "popularity": 87.26153846153846 }, { "name": "Mattie", "popularity": 77.77358490566037 }, { "name": "Willie", "popularity": 76.62337662337663 }, { "name": "Myrtle", "popularity": 72.81818181818181 }, { "name": "Ella", "popularity": 71.80597014925372 }, { "name": "Dianne", "popularity": 69.65454545454546 }, { "name": "Jessie", "popularity": 66.37096774193549 }, { "name": "Glenda", "popularity": 66 }, { "name": "Billie", "popularity": 64.05882352941177 }, { "name": "Bessie", "popularity": 63.86153846153846 }, { "name": "Margie", "popularity": 62.016129032258064 }, { "name": "Leona", "popularity": 61.55769230769231 }, { "name": "Rosa", "popularity": 55.984848484848484 }, { "name": "Pearl", "popularity": 54.18333333333333 } ] }, { "gender": "M", "by_name": [ { "name": "Johnnie", "popularity": 81.48076923076923 }, { "name": "Alvin", "popularity": 78.75324675324676 }, { "name": "Troy", "popularity": 77.78571428571429 }, { "name": "Sam", "popularity": 76.13461538461539 }, { "name": "Milton", "popularity": 74.35 }, { "name": "Herman", "popularity": 69.8 }, { "name": "Jimmie", "popularity": 67.33333333333333 }, { "name": "Micheal", "popularity": 65.76363636363637 }, { "name": "Calvin", "popularity": 64.02702702702703 }, { "name": "Bryan", "popularity": 58.450980392156865 }, { "name": "Charlie", "popularity": 53.55223880597015 }, { "name": "Leon", "popularity": 50.98717948717949 }, { "name": "Lester", "popularity": 46.89855072463768 }, { "name": "Eddie", "popularity": 44.76288659793814 }, { "name": "Chris", "popularity": 44.03389830508475 } ] } ] }, { "state": "MA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maureen", "popularity": 153.3421052631579 }, { "name": "Dianne", "popularity": 102.27272727272727 }, { "name": "Constance", "popularity": 73.14473684210526 }, { "name": "Jeanne", "popularity": 70.7127659574468 }, { "name": "Gertrude", "popularity": 70.45454545454545 }, { "name": "Emily", "popularity": 70.22222222222223 }, { "name": "Carole", "popularity": 68.41791044776119 }, { "name": "Marion", "popularity": 66.61386138613861 }, { "name": "Eileen", "popularity": 66 }, { "name": "Andrea", "popularity": 64.34782608695652 }, { "name": "Joanne", "popularity": 63.858333333333334 }, { "name": "Laurie", "popularity": 62.08641975308642 }, { "name": "Marcia", "popularity": 61.7972972972973 }, { "name": "Stella", "popularity": 60.333333333333336 }, { "name": "Christina", "popularity": 55.607142857142854 } ] }, { "gender": "M", "by_name": [ { "name": "Jonathan", "popularity": 100.01886792452831 }, { "name": "Manuel", "popularity": 96.13725490196079 }, { "name": "Leo", "popularity": 89.28048780487805 }, { "name": "Nicholas", "popularity": 88.66101694915254 }, { "name": "Francis", "popularity": 74.56666666666666 }, { "name": "Chester", "popularity": 62.328125 }, { "name": "Frederick", "popularity": 52.904 }, { "name": "Arnold", "popularity": 48.785714285714285 }, { "name": "Warren", "popularity": 46.94252873563219 }, { "name": "Alfred", "popularity": 46.45238095238095 }, { "name": "Philip", "popularity": 43.02054794520548 }, { "name": "Barry", "popularity": 39.42391304347826 }, { "name": "Gordon", "popularity": 39.16867469879518 }, { "name": "Joel", "popularity": 39.101694915254235 }, { "name": "Gilbert", "popularity": 38.39344262295082 } ] } ] }, { "state": "MD", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Terry", "popularity": 43.6 }, { "name": "Christina", "popularity": 35.160714285714285 }, { "name": "Regina", "popularity": 34.333333333333336 }, { "name": "Delores", "popularity": 32.352112676056336 }, { "name": "Agnes", "popularity": 31.930555555555557 }, { "name": "Emily", "popularity": 31.09259259259259 }, { "name": "Gwendolyn", "popularity": 30.637931034482758 }, { "name": "Carole", "popularity": 29.134328358208954 }, { "name": "Michele", "popularity": 27.133333333333333 }, { "name": "Pearl", "popularity": 26.833333333333332 }, { "name": "Leslie", "popularity": 26.82191780821918 }, { "name": "Constance", "popularity": 25.907894736842106 }, { "name": "Valerie", "popularity": 25.75609756097561 }, { "name": "Renee", "popularity": 25.578125 }, { "name": "Myrtle", "popularity": 25.472727272727273 } ] }, { "gender": "M", "by_name": [ { "name": "Milton", "popularity": 43.71666666666667 }, { "name": "Franklin", "popularity": 43.0655737704918 }, { "name": "Bryan", "popularity": 40.01960784313726 }, { "name": "Jerome", "popularity": 35.067567567567565 }, { "name": "Jonathan", "popularity": 34.84905660377358 }, { "name": "Vernon", "popularity": 32.93589743589744 }, { "name": "Calvin", "popularity": 32.391891891891895 }, { "name": "Elmer", "popularity": 31.70769230769231 }, { "name": "Gilbert", "popularity": 31.295081967213115 }, { "name": "Bernard", "popularity": 26.88785046728972 }, { "name": "Benjamin", "popularity": 26.61842105263158 }, { "name": "Wesley", "popularity": 24.372549019607842 }, { "name": "Herman", "popularity": 23.728571428571428 }, { "name": "Harvey", "popularity": 23.370967741935484 }, { "name": "Lewis", "popularity": 23.069444444444443 } ] } ] }, { "state": "ME", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Rachel", "popularity": 25.915254237288135 }, { "name": "Constance", "popularity": 23.32894736842105 }, { "name": "Dianne", "popularity": 16.418181818181818 }, { "name": "Arlene", "popularity": 15.962025316455696 }, { "name": "Laurie", "popularity": 15.45679012345679 }, { "name": "Leona", "popularity": 14.807692307692308 }, { "name": "Maxine", "popularity": 14.015625 }, { "name": "Pauline", "popularity": 13.8130081300813 }, { "name": "Charlene", "popularity": 13.56060606060606 }, { "name": "Terry", "popularity": 13.49090909090909 }, { "name": "Gertrude", "popularity": 13.116883116883116 }, { "name": "Marion", "popularity": 12.297029702970297 }, { "name": "Lorraine", "popularity": 10.51639344262295 }, { "name": "Marlene", "popularity": 10.447761194029852 }, { "name": "Pearl", "popularity": 9.766666666666667 } ] }, { "gender": "M", "by_name": [ { "name": "Arnold", "popularity": 19.767857142857142 }, { "name": "Leo", "popularity": 17.402439024390244 }, { "name": "Jonathan", "popularity": 14.452830188679245 }, { "name": "Leslie", "popularity": 13.293103448275861 }, { "name": "Gilbert", "popularity": 12.311475409836065 }, { "name": "Lewis", "popularity": 12.222222222222221 }, { "name": "Gordon", "popularity": 11.963855421686747 }, { "name": "Joel", "popularity": 11.627118644067796 }, { "name": "Chester", "popularity": 11.203125 }, { "name": "Philip", "popularity": 10.506849315068493 }, { "name": "Wesley", "popularity": 10.490196078431373 }, { "name": "Jon", "popularity": 9.80952380952381 }, { "name": "Duane", "popularity": 9.53448275862069 }, { "name": "Leon", "popularity": 9.461538461538462 }, { "name": "Franklin", "popularity": 9.40983606557377 } ] } ] }, { "state": "MI", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kay", "popularity": 119.94736842105263 }, { "name": "Renee", "popularity": 109.890625 }, { "name": "Leona", "popularity": 109.5 }, { "name": "Colleen", "popularity": 109.15625 }, { "name": "Marlene", "popularity": 100.53731343283582 }, { "name": "Dianne", "popularity": 95.18181818181819 }, { "name": "Marcia", "popularity": 93.58108108108108 }, { "name": "Beth", "popularity": 91.82608695652173 }, { "name": "Jill", "popularity": 91.74025974025975 }, { "name": "Maxine", "popularity": 87.71875 }, { "name": "Marsha", "popularity": 86.17857142857143 }, { "name": "Terry", "popularity": 85.2909090909091 }, { "name": "Carole", "popularity": 83.70149253731343 }, { "name": "Dawn", "popularity": 81.80188679245283 }, { "name": "Charlene", "popularity": 80.65151515151516 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 162.56896551724137 }, { "name": "Dan", "popularity": 106.16071428571429 }, { "name": "Bradley", "popularity": 100.4074074074074 }, { "name": "Bryan", "popularity": 98.33333333333333 }, { "name": "Gordon", "popularity": 94.25301204819277 }, { "name": "Chris", "popularity": 91.49152542372882 }, { "name": "Micheal", "popularity": 91.03636363636363 }, { "name": "Jon", "popularity": 88.22222222222223 }, { "name": "Arnold", "popularity": 87.07142857142857 }, { "name": "Bob", "popularity": 85.89090909090909 }, { "name": "Jeff", "popularity": 85.06451612903226 }, { "name": "Tom", "popularity": 83.21333333333334 }, { "name": "Wesley", "popularity": 80.31372549019608 }, { "name": "Jerome", "popularity": 75.17567567567568 }, { "name": "Jeffery", "popularity": 73.28915662650603 } ] } ] }, { "state": "MN", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Colleen", "popularity": 77.25 }, { "name": "Marlene", "popularity": 68.53731343283582 }, { "name": "Delores", "popularity": 65.88732394366197 }, { "name": "Leona", "popularity": 65.01923076923077 }, { "name": "Kay", "popularity": 64.01754385964912 }, { "name": "Dianne", "popularity": 62.38181818181818 }, { "name": "Renee", "popularity": 55.390625 }, { "name": "Jill", "popularity": 49.467532467532465 }, { "name": "Myrtle", "popularity": 47 }, { "name": "Arlene", "popularity": 46.30379746835443 }, { "name": "Laurie", "popularity": 46.28395061728395 }, { "name": "Marian", "popularity": 45.38461538461539 }, { "name": "Beth", "popularity": 45.289855072463766 }, { "name": "Joy", "popularity": 43.18867924528302 }, { "name": "Jeanne", "popularity": 41.5531914893617 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 146.13793103448276 }, { "name": "Bradley", "popularity": 134.03703703703704 }, { "name": "Arnold", "popularity": 84.67857142857143 }, { "name": "Jon", "popularity": 82.87301587301587 }, { "name": "Jerome", "popularity": 80.86486486486487 }, { "name": "Dean", "popularity": 77.6103896103896 }, { "name": "Joel", "popularity": 70.23728813559322 }, { "name": "Gordon", "popularity": 62.8433734939759 }, { "name": "Todd", "popularity": 60.10526315789474 }, { "name": "Vernon", "popularity": 54.35897435897436 }, { "name": "Wesley", "popularity": 51.03921568627451 }, { "name": "Leslie", "popularity": 49.56896551724138 }, { "name": "Dan", "popularity": 49.44642857142857 }, { "name": "Troy", "popularity": 49.42857142857143 }, { "name": "Harvey", "popularity": 48.38709677419355 } ] } ] }, { "state": "MO", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Glenda", "popularity": 79.51612903225806 }, { "name": "Wilma", "popularity": 76.33734939759036 }, { "name": "Carla", "popularity": 71.66071428571429 }, { "name": "Billie", "popularity": 69.6470588235294 }, { "name": "Leona", "popularity": 69.23076923076923 }, { "name": "Marsha", "popularity": 68.69642857142857 }, { "name": "Georgia", "popularity": 65.46969696969697 }, { "name": "Maxine", "popularity": 61.515625 }, { "name": "Terry", "popularity": 60.58181818181818 }, { "name": "Joy", "popularity": 54.283018867924525 }, { "name": "Vickie", "popularity": 53.20634920634921 }, { "name": "Myrtle", "popularity": 53.018181818181816 }, { "name": "Patsy", "popularity": 52.68055555555556 }, { "name": "Nellie", "popularity": 51.95 }, { "name": "Christina", "popularity": 51.464285714285715 } ] }, { "gender": "M", "by_name": [ { "name": "Bob", "popularity": 94.50909090909092 }, { "name": "Jimmie", "popularity": 71 }, { "name": "Elmer", "popularity": 70.96923076923076 }, { "name": "Cecil", "popularity": 70.57142857142857 }, { "name": "Glen", "popularity": 62.65625 }, { "name": "Bryan", "popularity": 59.64705882352941 }, { "name": "Wesley", "popularity": 57.27450980392157 }, { "name": "Leslie", "popularity": 55.96551724137931 }, { "name": "Micheal", "popularity": 54.872727272727275 }, { "name": "Darrell", "popularity": 54.77142857142857 }, { "name": "Vernon", "popularity": 53.73076923076923 }, { "name": "Lester", "popularity": 52.971014492753625 }, { "name": "Floyd", "popularity": 50.853658536585364 }, { "name": "Bradley", "popularity": 50.7962962962963 }, { "name": "Chris", "popularity": 50.54237288135593 } ] } ] }, { "state": "MS", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Mattie", "popularity": 205.64150943396226 }, { "name": "Willie", "popularity": 167.0909090909091 }, { "name": "Lillie", "popularity": 150.8 }, { "name": "Minnie", "popularity": 146.91071428571428 }, { "name": "Jessie", "popularity": 114.53225806451613 }, { "name": "Bessie", "popularity": 108.47692307692307 }, { "name": "Ella", "popularity": 82.08955223880596 }, { "name": "Carrie", "popularity": 73.33823529411765 }, { "name": "Georgia", "popularity": 70.92424242424242 }, { "name": "Annie", "popularity": 68.70779220779221 }, { "name": "Billie", "popularity": 66.19607843137256 }, { "name": "Ida", "popularity": 59.56578947368421 }, { "name": "Myrtle", "popularity": 57.38181818181818 }, { "name": "Glenda", "popularity": 55.25806451612903 }, { "name": "Margie", "popularity": 54.645161290322584 } ] }, { "gender": "M", "by_name": [ { "name": "Johnnie", "popularity": 183.28846153846155 }, { "name": "Jimmie", "popularity": 139.16666666666666 }, { "name": "Charlie", "popularity": 123.14925373134328 }, { "name": "Sam", "popularity": 106.73076923076923 }, { "name": "Eddie", "popularity": 83.23711340206185 }, { "name": "Tommy", "popularity": 56.19512195121951 }, { "name": "Cecil", "popularity": 56.035714285714285 }, { "name": "Willie", "popularity": 54.85526315789474 }, { "name": "Milton", "popularity": 54.13333333333333 }, { "name": "Calvin", "popularity": 47.91891891891892 }, { "name": "Herman", "popularity": 46.9 }, { "name": "Lee", "popularity": 44.6078431372549 }, { "name": "Leon", "popularity": 42.666666666666664 }, { "name": "Clyde", "popularity": 39.86666666666667 }, { "name": "Curtis", "popularity": 39.86407766990291 } ] } ] }, { "state": "MT", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Colleen", "popularity": 14.859375 }, { "name": "Leona", "popularity": 13.153846153846153 }, { "name": "Marlene", "popularity": 11.537313432835822 }, { "name": "Kay", "popularity": 11.385964912280702 }, { "name": "Carla", "popularity": 10.053571428571429 }, { "name": "Billie", "popularity": 9.392156862745098 }, { "name": "Myrtle", "popularity": 9.036363636363637 }, { "name": "Maxine", "popularity": 8.890625 }, { "name": "Terry", "popularity": 8.763636363636364 }, { "name": "Georgia", "popularity": 7.863636363636363 }, { "name": "Agnes", "popularity": 7.833333333333333 }, { "name": "Joy", "popularity": 7.811320754716981 }, { "name": "Laurie", "popularity": 7.802469135802469 }, { "name": "Viola", "popularity": 7.540983606557377 }, { "name": "Marian", "popularity": 7.17948717948718 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 19.724137931034484 }, { "name": "Dan", "popularity": 18.25 }, { "name": "Bob", "popularity": 16.763636363636362 }, { "name": "Wesley", "popularity": 13.96078431372549 }, { "name": "Leslie", "popularity": 13.931034482758621 }, { "name": "Jim", "popularity": 10.773809523809524 }, { "name": "Tom", "popularity": 10.626666666666667 }, { "name": "Gordon", "popularity": 10.373493975903614 }, { "name": "Bradley", "popularity": 10.148148148148149 }, { "name": "Dean", "popularity": 10.142857142857142 }, { "name": "Glen", "popularity": 9.96875 }, { "name": "Arnold", "popularity": 9.25 }, { "name": "Bill", "popularity": 8.851063829787234 }, { "name": "Gene", "popularity": 8.845070422535212 }, { "name": "Bryan", "popularity": 8.490196078431373 } ] } ] }, { "state": "NC", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Mattie", "popularity": 156.0188679245283 }, { "name": "Minnie", "popularity": 146.69642857142858 }, { "name": "Lillie", "popularity": 139.41538461538462 }, { "name": "Myrtle", "popularity": 132.92727272727274 }, { "name": "Rachel", "popularity": 125.32203389830508 }, { "name": "Rosa", "popularity": 123.53030303030303 }, { "name": "Nellie", "popularity": 121.41666666666667 }, { "name": "Bessie", "popularity": 111.98461538461538 }, { "name": "Ella", "popularity": 103.64179104477611 }, { "name": "Margie", "popularity": 103.01612903225806 }, { "name": "Jessie", "popularity": 99.54838709677419 }, { "name": "Lucy", "popularity": 97.515625 }, { "name": "Carrie", "popularity": 96.77941176470588 }, { "name": "Glenda", "popularity": 95.38709677419355 }, { "name": "Gwendolyn", "popularity": 94.70689655172414 } ] }, { "gender": "M", "by_name": [ { "name": "Charlie", "popularity": 174 }, { "name": "Johnnie", "popularity": 166.23076923076923 }, { "name": "Cecil", "popularity": 101.96428571428571 }, { "name": "Clyde", "popularity": 95.82666666666667 }, { "name": "Franklin", "popularity": 87.68852459016394 }, { "name": "Jimmie", "popularity": 86.03333333333333 }, { "name": "Harvey", "popularity": 85.35483870967742 }, { "name": "Ronnie", "popularity": 82.67816091954023 }, { "name": "Milton", "popularity": 76.98333333333333 }, { "name": "Jesse", "popularity": 75.53571428571429 }, { "name": "Herman", "popularity": 75.34285714285714 }, { "name": "Calvin", "popularity": 74.06756756756756 }, { "name": "Tommy", "popularity": 68.97560975609755 }, { "name": "Lewis", "popularity": 68.51388888888889 }, { "name": "Micheal", "popularity": 68.27272727272727 } ] } ] }, { "state": "ND", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Leona", "popularity": 26.557692307692307 }, { "name": "Delores", "popularity": 22.91549295774648 }, { "name": "Viola", "popularity": 20.885245901639344 }, { "name": "Marlene", "popularity": 20.65671641791045 }, { "name": "Myrtle", "popularity": 19.98181818181818 }, { "name": "Agnes", "popularity": 18 }, { "name": "Colleen", "popularity": 15.359375 }, { "name": "Arlene", "popularity": 14.354430379746836 }, { "name": "Pearl", "popularity": 14.266666666666667 }, { "name": "Kay", "popularity": 13.736842105263158 }, { "name": "Esther", "popularity": 11.981308411214954 }, { "name": "Marian", "popularity": 11.564102564102564 }, { "name": "Maxine", "popularity": 11.546875 }, { "name": "Elsie", "popularity": 11.192307692307692 }, { "name": "Dianne", "popularity": 10.872727272727273 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 57.5 }, { "name": "Arnold", "popularity": 28.303571428571427 }, { "name": "Bradley", "popularity": 26.37037037037037 }, { "name": "Vernon", "popularity": 19.846153846153847 }, { "name": "Dean", "popularity": 19.805194805194805 }, { "name": "Wesley", "popularity": 19.725490196078432 }, { "name": "Leslie", "popularity": 19.43103448275862 }, { "name": "Elmer", "popularity": 19.184615384615384 }, { "name": "Jerome", "popularity": 19.04054054054054 }, { "name": "Gordon", "popularity": 18.6144578313253 }, { "name": "Alvin", "popularity": 15.142857142857142 }, { "name": "Leo", "popularity": 15 }, { "name": "Lloyd", "popularity": 14.597701149425287 }, { "name": "Jon", "popularity": 12.984126984126984 }, { "name": "Harvey", "popularity": 12.96774193548387 } ] } ] }, { "state": "NE", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maxine", "popularity": 40.796875 }, { "name": "Leona", "popularity": 39.44230769230769 }, { "name": "Kay", "popularity": 31.31578947368421 }, { "name": "Delores", "popularity": 26.788732394366196 }, { "name": "Marlene", "popularity": 26.507462686567163 }, { "name": "Viola", "popularity": 25.42622950819672 }, { "name": "Colleen", "popularity": 22.28125 }, { "name": "Marcia", "popularity": 20.013513513513512 }, { "name": "Wilma", "popularity": 19.987951807228917 }, { "name": "Arlene", "popularity": 19.31645569620253 }, { "name": "Vera", "popularity": 18.63235294117647 }, { "name": "Dianne", "popularity": 18.036363636363635 }, { "name": "Joy", "popularity": 17.867924528301888 }, { "name": "Marian", "popularity": 16.423076923076923 }, { "name": "Beth", "popularity": 16.17391304347826 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 57.206896551724135 }, { "name": "Bradley", "popularity": 38 }, { "name": "Bob", "popularity": 36.90909090909091 }, { "name": "Dean", "popularity": 32.532467532467535 }, { "name": "Glen", "popularity": 29.265625 }, { "name": "Gene", "popularity": 25.845070422535212 }, { "name": "Dan", "popularity": 25.839285714285715 }, { "name": "Arnold", "popularity": 25.803571428571427 }, { "name": "Wesley", "popularity": 25.647058823529413 }, { "name": "Elmer", "popularity": 25.076923076923077 }, { "name": "Leslie", "popularity": 24.5 }, { "name": "Jim", "popularity": 22.642857142857142 }, { "name": "Jon", "popularity": 21.603174603174605 }, { "name": "Vernon", "popularity": 21.602564102564102 }, { "name": "Bryan", "popularity": 21.45098039215686 } ] } ] }, { "state": "NH", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Rachel", "popularity": 13.813559322033898 }, { "name": "Constance", "popularity": 10.81578947368421 }, { "name": "Pauline", "popularity": 9.560975609756097 }, { "name": "Dianne", "popularity": 7.363636363636363 }, { "name": "Maureen", "popularity": 7.0131578947368425 }, { "name": "Marion", "popularity": 6.96039603960396 }, { "name": "Laurie", "popularity": 6.91358024691358 }, { "name": "Lorraine", "popularity": 6.827868852459017 }, { "name": "Leona", "popularity": 6.653846153846154 }, { "name": "Gertrude", "popularity": 6.454545454545454 }, { "name": "Stella", "popularity": 6.12280701754386 }, { "name": "Jeanne", "popularity": 6.0212765957446805 }, { "name": "Arlene", "popularity": 5.962025316455696 }, { "name": "Wendy", "popularity": 5.876404494382022 }, { "name": "Beatrice", "popularity": 5.347368421052631 } ] }, { "gender": "M", "by_name": [ { "name": "Leo", "popularity": 12.951219512195122 }, { "name": "Jonathan", "popularity": 12.50943396226415 }, { "name": "Bradley", "popularity": 6.944444444444445 }, { "name": "Gordon", "popularity": 6.686746987951807 }, { "name": "Leon", "popularity": 6.641025641025641 }, { "name": "Jon", "popularity": 6.142857142857143 }, { "name": "Arnold", "popularity": 5.875 }, { "name": "Norman", "popularity": 5.3776223776223775 }, { "name": "Chester", "popularity": 4.53125 }, { "name": "Leslie", "popularity": 4.482758620689655 }, { "name": "Nicholas", "popularity": 4.440677966101695 }, { "name": "Bryan", "popularity": 4.352941176470588 }, { "name": "Theodore", "popularity": 4.071428571428571 }, { "name": "Philip", "popularity": 3.8904109589041096 }, { "name": "Warren", "popularity": 3.8275862068965516 } ] } ] }, { "state": "NJ", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maureen", "popularity": 93.82894736842105 }, { "name": "Michele", "popularity": 76.53333333333333 }, { "name": "Eileen", "popularity": 72.38613861386139 }, { "name": "Emily", "popularity": 68.70370370370371 }, { "name": "Stella", "popularity": 66.96491228070175 }, { "name": "Christina", "popularity": 64.80357142857143 }, { "name": "Colleen", "popularity": 63.421875 }, { "name": "Carole", "popularity": 63.04477611940298 }, { "name": "Arlene", "popularity": 61.50632911392405 }, { "name": "Andrea", "popularity": 61.04347826086956 }, { "name": "Renee", "popularity": 57.078125 }, { "name": "Regina", "popularity": 55.861111111111114 }, { "name": "Marion", "popularity": 55.415841584158414 }, { "name": "Valerie", "popularity": 51.98780487804878 }, { "name": "Jill", "popularity": 51.98701298701299 } ] }, { "gender": "M", "by_name": [ { "name": "Nicholas", "popularity": 160.4915254237288 }, { "name": "Jonathan", "popularity": 69.75471698113208 }, { "name": "Vincent", "popularity": 69.21818181818182 }, { "name": "Theodore", "popularity": 51.326530612244895 }, { "name": "Chester", "popularity": 47.171875 }, { "name": "Arnold", "popularity": 44.607142857142854 }, { "name": "Benjamin", "popularity": 43.723684210526315 }, { "name": "Barry", "popularity": 42.42391304347826 }, { "name": "Milton", "popularity": 41.916666666666664 }, { "name": "Frederick", "popularity": 40.648 }, { "name": "Sam", "popularity": 40.46153846153846 }, { "name": "Warren", "popularity": 39.85057471264368 }, { "name": "Victor", "popularity": 39.0531914893617 }, { "name": "Chris", "popularity": 38.66101694915254 }, { "name": "Jerome", "popularity": 38.36486486486486 } ] } ] }, { "state": "NM", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Lucy", "popularity": 35.25 }, { "name": "Stella", "popularity": 27.614035087719298 }, { "name": "Viola", "popularity": 22.524590163934427 }, { "name": "Patsy", "popularity": 15.958333333333334 }, { "name": "Rosa", "popularity": 15.848484848484848 }, { "name": "Carla", "popularity": 15.75 }, { "name": "Christina", "popularity": 15.321428571428571 }, { "name": "Nellie", "popularity": 15.216666666666667 }, { "name": "Maria", "popularity": 14.922077922077921 }, { "name": "Emily", "popularity": 14.574074074074074 }, { "name": "Rachel", "popularity": 13.864406779661017 }, { "name": "Billie", "popularity": 13.529411764705882 }, { "name": "Terry", "popularity": 12.50909090909091 }, { "name": "Margie", "popularity": 12.241935483870968 }, { "name": "Yvonne", "popularity": 12.155844155844155 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 122.6078431372549 }, { "name": "Jose", "popularity": 76.33766233766234 }, { "name": "Gilbert", "popularity": 52.83606557377049 }, { "name": "Sam", "popularity": 18.153846153846153 }, { "name": "Tommy", "popularity": 17.926829268292682 }, { "name": "Tony", "popularity": 17.07070707070707 }, { "name": "Chris", "popularity": 15.576271186440678 }, { "name": "Jimmie", "popularity": 15.35 }, { "name": "Johnnie", "popularity": 14.48076923076923 }, { "name": "Dan", "popularity": 14.142857142857142 }, { "name": "Tom", "popularity": 13.706666666666667 }, { "name": "Leo", "popularity": 13.097560975609756 }, { "name": "Benjamin", "popularity": 12.986842105263158 }, { "name": "Herman", "popularity": 12.3 }, { "name": "Charlie", "popularity": 12.298507462686567 } ] } ] }, { "state": "NV", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Leslie", "popularity": 2.9726027397260273 }, { "name": "Terry", "popularity": 2.9454545454545453 }, { "name": "Christina", "popularity": 2.9285714285714284 }, { "name": "Tracy", "popularity": 2.7027027027027026 }, { "name": "Carla", "popularity": 2.1607142857142856 }, { "name": "Colleen", "popularity": 1.921875 }, { "name": "Terri", "popularity": 1.8082191780821917 }, { "name": "Valerie", "popularity": 1.7317073170731707 }, { "name": "Laurie", "popularity": 1.728395061728395 }, { "name": "Jill", "popularity": 1.6233766233766234 }, { "name": "Renee", "popularity": 1.609375 }, { "name": "Kelly", "popularity": 1.608695652173913 }, { "name": "Kim", "popularity": 1.5051546391752577 }, { "name": "Andrea", "popularity": 1.4927536231884058 }, { "name": "Tina", "popularity": 1.4150943396226414 } ] }, { "gender": "M", "by_name": [ { "name": "Troy", "popularity": 3.767857142857143 }, { "name": "Bryan", "popularity": 2.9607843137254903 }, { "name": "Jon", "popularity": 2.7301587301587302 }, { "name": "Chris", "popularity": 2.5254237288135593 }, { "name": "Micheal", "popularity": 2.3454545454545452 }, { "name": "Jeff", "popularity": 2.2580645161290325 }, { "name": "Dan", "popularity": 1.9107142857142858 }, { "name": "Mike", "popularity": 1.6754385964912282 }, { "name": "Jim", "popularity": 1.630952380952381 }, { "name": "Bradley", "popularity": 1.4444444444444444 }, { "name": "Todd", "popularity": 1.2736842105263158 }, { "name": "Tom", "popularity": 1.2 }, { "name": "Dean", "popularity": 1.1688311688311688 }, { "name": "Bob", "popularity": 1.1272727272727272 }, { "name": "Bill", "popularity": 1.1170212765957446 } ] } ] }, { "state": "NY", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maureen", "popularity": 306.7894736842105 }, { "name": "Eileen", "popularity": 237.59405940594058 }, { "name": "Emily", "popularity": 212.40740740740742 }, { "name": "Renee", "popularity": 203.53125 }, { "name": "Arlene", "popularity": 200.0126582278481 }, { "name": "Christina", "popularity": 196.53571428571428 }, { "name": "Andrea", "popularity": 194.82608695652175 }, { "name": "Lucy", "popularity": 190.140625 }, { "name": "Gertrude", "popularity": 187 }, { "name": "Marion", "popularity": 178.16831683168317 }, { "name": "Carole", "popularity": 177.955223880597 }, { "name": "Michele", "popularity": 175.85555555555555 }, { "name": "Regina", "popularity": 174.15277777777777 }, { "name": "Colleen", "popularity": 170.546875 }, { "name": "Pearl", "popularity": 161.63333333333333 } ] }, { "gender": "M", "by_name": [ { "name": "Nicholas", "popularity": 446.7118644067797 }, { "name": "Jonathan", "popularity": 272.07547169811323 }, { "name": "Vincent", "popularity": 241.3 }, { "name": "Arnold", "popularity": 230.71428571428572 }, { "name": "Joel", "popularity": 202.4406779661017 }, { "name": "Milton", "popularity": 195.36666666666667 }, { "name": "Sam", "popularity": 186.26923076923077 }, { "name": "Jose", "popularity": 177.88311688311688 }, { "name": "Jerome", "popularity": 169.3918918918919 }, { "name": "Harvey", "popularity": 151.6451612903226 }, { "name": "Bernard", "popularity": 151.53271028037383 }, { "name": "Victor", "popularity": 141.35106382978722 }, { "name": "Benjamin", "popularity": 139.22368421052633 }, { "name": "Martin", "popularity": 137.6290322580645 }, { "name": "Edwin", "popularity": 136.89690721649484 } ] } ] }, { "state": "OH", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Beth", "popularity": 134.231884057971 }, { "name": "Marsha", "popularity": 127.96428571428571 }, { "name": "Christina", "popularity": 124.48214285714286 }, { "name": "Kay", "popularity": 116.05263157894737 }, { "name": "Carla", "popularity": 114.80357142857143 }, { "name": "Joy", "popularity": 104.67924528301887 }, { "name": "Marlene", "popularity": 104.02985074626865 }, { "name": "Marcia", "popularity": 101.5945945945946 }, { "name": "Vickie", "popularity": 100.80952380952381 }, { "name": "Sue", "popularity": 100.30588235294118 }, { "name": "Carole", "popularity": 98.3731343283582 }, { "name": "Jill", "popularity": 95.62337662337663 }, { "name": "Dianne", "popularity": 94.7090909090909 }, { "name": "Renee", "popularity": 94.515625 }, { "name": "Charlene", "popularity": 93.89393939393939 } ] }, { "gender": "M", "by_name": [ { "name": "Dan", "popularity": 123.83928571428571 }, { "name": "Bryan", "popularity": 123.37254901960785 }, { "name": "Jeff", "popularity": 117.46774193548387 }, { "name": "Bradley", "popularity": 114.37037037037037 }, { "name": "Bob", "popularity": 110.85454545454546 }, { "name": "Tom", "popularity": 104.70666666666666 }, { "name": "Jon", "popularity": 101.44444444444444 }, { "name": "Duane", "popularity": 101.03448275862068 }, { "name": "Chris", "popularity": 98.47457627118644 }, { "name": "Jonathan", "popularity": 97.45283018867924 }, { "name": "Nicholas", "popularity": 93.59322033898304 }, { "name": "Jeffery", "popularity": 91.91566265060241 }, { "name": "Elmer", "popularity": 90.33846153846154 }, { "name": "Micheal", "popularity": 87.76363636363637 }, { "name": "Chester", "popularity": 86.203125 } ] } ] }, { "state": "OK", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Billie", "popularity": 152.64705882352942 }, { "name": "Patsy", "popularity": 72.90277777777777 }, { "name": "Glenda", "popularity": 69.03225806451613 }, { "name": "Leona", "popularity": 59.53846153846154 }, { "name": "Joy", "popularity": 58.77358490566038 }, { "name": "Wilma", "popularity": 56.674698795180724 }, { "name": "Maxine", "popularity": 54.109375 }, { "name": "Margie", "popularity": 53.193548387096776 }, { "name": "Myrtle", "popularity": 52.527272727272724 }, { "name": "Georgia", "popularity": 49.31818181818182 }, { "name": "Jessie", "popularity": 49.17741935483871 }, { "name": "Vera", "popularity": 46.60294117647059 }, { "name": "Minnie", "popularity": 46.035714285714285 }, { "name": "Carla", "popularity": 45.089285714285715 }, { "name": "Viola", "popularity": 43.14754098360656 } ] }, { "gender": "M", "by_name": [ { "name": "Jimmie", "popularity": 98.63333333333334 }, { "name": "Cecil", "popularity": 90.03571428571429 }, { "name": "Bob", "popularity": 85.18181818181819 }, { "name": "Tommy", "popularity": 65.10975609756098 }, { "name": "Troy", "popularity": 63.125 }, { "name": "Johnnie", "popularity": 61.25 }, { "name": "Wesley", "popularity": 61 }, { "name": "Glen", "popularity": 55.078125 }, { "name": "Bill", "popularity": 53.765957446808514 }, { "name": "Floyd", "popularity": 52.21951219512195 }, { "name": "Elmer", "popularity": 50.6 }, { "name": "Gene", "popularity": 42.88732394366197 }, { "name": "Vernon", "popularity": 42.62820512820513 }, { "name": "Don", "popularity": 42.365591397849464 }, { "name": "Darrell", "popularity": 41.642857142857146 } ] } ] }, { "state": "OR", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Colleen", "popularity": 24.40625 }, { "name": "Kay", "popularity": 22.24561403508772 }, { "name": "Joy", "popularity": 20.20754716981132 }, { "name": "Carla", "popularity": 20.089285714285715 }, { "name": "Terry", "popularity": 19.654545454545456 }, { "name": "Maxine", "popularity": 19.640625 }, { "name": "Leslie", "popularity": 18.041095890410958 }, { "name": "Laurie", "popularity": 17.567901234567902 }, { "name": "Christina", "popularity": 17.178571428571427 }, { "name": "Terri", "popularity": 16.506849315068493 }, { "name": "Leona", "popularity": 15.942307692307692 }, { "name": "Vickie", "popularity": 15.777777777777779 }, { "name": "Jill", "popularity": 15.168831168831169 }, { "name": "Vicki", "popularity": 15.057471264367816 }, { "name": "Marlene", "popularity": 14.925373134328359 } ] }, { "gender": "M", "by_name": [ { "name": "Bob", "popularity": 39.03636363636364 }, { "name": "Dan", "popularity": 37.839285714285715 }, { "name": "Bradley", "popularity": 30.037037037037038 }, { "name": "Jeff", "popularity": 29.06451612903226 }, { "name": "Wesley", "popularity": 28.274509803921568 }, { "name": "Duane", "popularity": 28.120689655172413 }, { "name": "Jim", "popularity": 26.11904761904762 }, { "name": "Jon", "popularity": 25.761904761904763 }, { "name": "Troy", "popularity": 24.589285714285715 }, { "name": "Micheal", "popularity": 24.381818181818183 }, { "name": "Chris", "popularity": 22.694915254237287 }, { "name": "Tom", "popularity": 20.69333333333333 }, { "name": "Leslie", "popularity": 20.120689655172413 }, { "name": "Bryan", "popularity": 20.11764705882353 }, { "name": "Gordon", "popularity": 20 } ] } ] }, { "state": "PA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Stella", "popularity": 201.98245614035088 }, { "name": "Agnes", "popularity": 167.22222222222223 }, { "name": "Leona", "popularity": 163.34615384615384 }, { "name": "Marlene", "popularity": 159.61194029850745 }, { "name": "Marian", "popularity": 156 }, { "name": "Regina", "popularity": 155.34722222222223 }, { "name": "Beth", "popularity": 149.36231884057972 }, { "name": "Emily", "popularity": 147.42592592592592 }, { "name": "Pearl", "popularity": 146.03333333333333 }, { "name": "Carole", "popularity": 143.955223880597 }, { "name": "Sara", "popularity": 139.48 }, { "name": "Arlene", "popularity": 134.0379746835443 }, { "name": "Gertrude", "popularity": 132.92207792207793 }, { "name": "Christina", "popularity": 129.44642857142858 }, { "name": "Colleen", "popularity": 125.453125 } ] }, { "gender": "M", "by_name": [ { "name": "Nicholas", "popularity": 231.79661016949152 }, { "name": "Chester", "popularity": 133.328125 }, { "name": "Barry", "popularity": 132.45652173913044 }, { "name": "Elmer", "popularity": 130.3230769230769 }, { "name": "Franklin", "popularity": 121.42622950819673 }, { "name": "Jonathan", "popularity": 117.47169811320755 }, { "name": "Jay", "popularity": 113.49350649350649 }, { "name": "Francis", "popularity": 107.70666666666666 }, { "name": "Bernard", "popularity": 105.37383177570094 }, { "name": "Theodore", "popularity": 105.01020408163265 }, { "name": "Lester", "popularity": 103.78260869565217 }, { "name": "Lewis", "popularity": 101.25 }, { "name": "Bryan", "popularity": 101.15686274509804 }, { "name": "Harvey", "popularity": 100.3225806451613 }, { "name": "Benjamin", "popularity": 98.27631578947368 } ] } ] }, { "state": "RI", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maureen", "popularity": 19.81578947368421 }, { "name": "Constance", "popularity": 13.605263157894736 }, { "name": "Dianne", "popularity": 13.181818181818182 }, { "name": "Jeanne", "popularity": 11.617021276595745 }, { "name": "Colleen", "popularity": 10.890625 }, { "name": "Gertrude", "popularity": 10.571428571428571 }, { "name": "Emily", "popularity": 10.38888888888889 }, { "name": "Lucy", "popularity": 9.703125 }, { "name": "Laurie", "popularity": 9.481481481481481 }, { "name": "Eileen", "popularity": 8.861386138613861 }, { "name": "Leslie", "popularity": 8.479452054794521 }, { "name": "Agnes", "popularity": 8.194444444444445 }, { "name": "Gail", "popularity": 8.049586776859504 }, { "name": "Marion", "popularity": 7.98019801980198 }, { "name": "Rachel", "popularity": 7.88135593220339 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 26.49019607843137 }, { "name": "Leo", "popularity": 17.78048780487805 }, { "name": "Nicholas", "popularity": 16.423728813559322 }, { "name": "Jonathan", "popularity": 9.962264150943396 }, { "name": "Alfred", "popularity": 9.936507936507937 }, { "name": "Vincent", "popularity": 9.672727272727272 }, { "name": "Gilbert", "popularity": 8.901639344262295 }, { "name": "Frederick", "popularity": 7.208 }, { "name": "Francis", "popularity": 7.18 }, { "name": "Milton", "popularity": 6.266666666666667 }, { "name": "Norman", "popularity": 6.062937062937063 }, { "name": "Arnold", "popularity": 5.767857142857143 }, { "name": "Gordon", "popularity": 5.024096385542169 }, { "name": "Ernest", "popularity": 4.849673202614379 }, { "name": "Peter", "popularity": 4.8304347826086955 } ] } ] }, { "state": "SC", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Mattie", "popularity": 149.28301886792454 }, { "name": "Rosa", "popularity": 140.65151515151516 }, { "name": "Lillie", "popularity": 137.90769230769232 }, { "name": "Minnie", "popularity": 111.51785714285714 }, { "name": "Carrie", "popularity": 107.16176470588235 }, { "name": "Willie", "popularity": 97.37662337662337 }, { "name": "Jessie", "popularity": 93.6774193548387 }, { "name": "Bessie", "popularity": 83.36923076923077 }, { "name": "Ella", "popularity": 78.02985074626865 }, { "name": "Sara", "popularity": 67.89333333333333 }, { "name": "Margie", "popularity": 61.74193548387097 }, { "name": "Viola", "popularity": 59.278688524590166 }, { "name": "Myrtle", "popularity": 58.90909090909091 }, { "name": "Nellie", "popularity": 58.016666666666666 }, { "name": "Emily", "popularity": 56.75925925925926 } ] }, { "gender": "M", "by_name": [ { "name": "Johnnie", "popularity": 124.63461538461539 }, { "name": "Charlie", "popularity": 89.26865671641791 }, { "name": "Sam", "popularity": 85.75 }, { "name": "Franklin", "popularity": 64.57377049180327 }, { "name": "Benjamin", "popularity": 59.56578947368421 }, { "name": "Jimmie", "popularity": 59.13333333333333 }, { "name": "Leroy", "popularity": 53.51851851851852 }, { "name": "Lewis", "popularity": 51.013888888888886 }, { "name": "Cecil", "popularity": 50.892857142857146 }, { "name": "Calvin", "popularity": 48.067567567567565 }, { "name": "Leon", "popularity": 42.80769230769231 }, { "name": "Clyde", "popularity": 42.8 }, { "name": "Herman", "popularity": 41.75714285714286 }, { "name": "Eddie", "popularity": 41.21649484536083 }, { "name": "Tommy", "popularity": 39.548780487804876 } ] } ] }, { "state": "SD", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Leona", "popularity": 21.5 }, { "name": "Delores", "popularity": 20.802816901408452 }, { "name": "Viola", "popularity": 19.360655737704917 }, { "name": "Kay", "popularity": 18.50877192982456 }, { "name": "Maxine", "popularity": 18.34375 }, { "name": "Marlene", "popularity": 15.970149253731343 }, { "name": "Dianne", "popularity": 14.290909090909091 }, { "name": "Arlene", "popularity": 13.012658227848101 }, { "name": "Colleen", "popularity": 12.6875 }, { "name": "Myrtle", "popularity": 12.654545454545454 }, { "name": "Carla", "popularity": 11.482142857142858 }, { "name": "Pearl", "popularity": 10.916666666666666 }, { "name": "Agnes", "popularity": 10.61111111111111 }, { "name": "Joy", "popularity": 9.924528301886792 }, { "name": "Vera", "popularity": 9.397058823529411 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 41.44827586206897 }, { "name": "Bradley", "popularity": 22.055555555555557 }, { "name": "Arnold", "popularity": 20.357142857142858 }, { "name": "Dean", "popularity": 18.506493506493506 }, { "name": "Wesley", "popularity": 17.15686274509804 }, { "name": "Leslie", "popularity": 16.810344827586206 }, { "name": "Elmer", "popularity": 15.892307692307693 }, { "name": "Darrell", "popularity": 14.728571428571428 }, { "name": "Vernon", "popularity": 13.897435897435898 }, { "name": "Gene", "popularity": 13.732394366197184 }, { "name": "Alvin", "popularity": 13.35064935064935 }, { "name": "Glen", "popularity": 13.265625 }, { "name": "Troy", "popularity": 13.214285714285714 }, { "name": "Harvey", "popularity": 12.838709677419354 }, { "name": "Todd", "popularity": 12.557894736842105 } ] } ] }, { "state": "TN", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Mattie", "popularity": 131.88679245283018 }, { "name": "Billie", "popularity": 115.88235294117646 }, { "name": "Glenda", "popularity": 90.40322580645162 }, { "name": "Willie", "popularity": 89.22077922077922 }, { "name": "Minnie", "popularity": 88.14285714285714 }, { "name": "Patsy", "popularity": 85.125 }, { "name": "Nellie", "popularity": 78.28333333333333 }, { "name": "Myrtle", "popularity": 78.0909090909091 }, { "name": "Georgia", "popularity": 75.78787878787878 }, { "name": "Vickie", "popularity": 74.5079365079365 }, { "name": "Jessie", "popularity": 72.20967741935483 }, { "name": "Wilma", "popularity": 72.20481927710843 }, { "name": "Bessie", "popularity": 71.4 }, { "name": "Lillie", "popularity": 70.27692307692308 }, { "name": "Margie", "popularity": 68.69354838709677 } ] }, { "gender": "M", "by_name": [ { "name": "Cecil", "popularity": 82.125 }, { "name": "Charlie", "popularity": 79.64179104477611 }, { "name": "Sam", "popularity": 77.92307692307692 }, { "name": "Johnnie", "popularity": 74.57692307692308 }, { "name": "Tommy", "popularity": 70.2439024390244 }, { "name": "Jimmie", "popularity": 69.16666666666667 }, { "name": "Clyde", "popularity": 65.8 }, { "name": "Ronnie", "popularity": 65.24137931034483 }, { "name": "Micheal", "popularity": 60.67272727272727 }, { "name": "Troy", "popularity": 57.42857142857143 }, { "name": "Franklin", "popularity": 55.98360655737705 }, { "name": "Ricky", "popularity": 53.06185567010309 }, { "name": "Herman", "popularity": 51.41428571428571 }, { "name": "Jimmy", "popularity": 48.91044776119403 }, { "name": "Bobby", "popularity": 48.616883116883116 } ] } ] }, { "state": "TX", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Billie", "popularity": 410.8627450980392 }, { "name": "Rosa", "popularity": 301.6515151515151 }, { "name": "Maria", "popularity": 227.46103896103895 }, { "name": "Patsy", "popularity": 218.65277777777777 }, { "name": "Glenda", "popularity": 186.66129032258064 }, { "name": "Margie", "popularity": 172.98387096774192 }, { "name": "Rachel", "popularity": 151 }, { "name": "Alma", "popularity": 150.25757575757575 }, { "name": "Minnie", "popularity": 148.89285714285714 }, { "name": "Willie", "popularity": 148.32467532467533 }, { "name": "Lillie", "popularity": 144.52307692307693 }, { "name": "Mattie", "popularity": 143.50943396226415 }, { "name": "Joy", "popularity": 137.50943396226415 }, { "name": "Jessie", "popularity": 133.75806451612902 }, { "name": "Carla", "popularity": 130.39285714285714 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 606.5882352941177 }, { "name": "Jose", "popularity": 592.4285714285714 }, { "name": "Johnnie", "popularity": 200.32692307692307 }, { "name": "Gilbert", "popularity": 195.9016393442623 }, { "name": "Jesse", "popularity": 188.0595238095238 }, { "name": "Jimmie", "popularity": 186.96666666666667 }, { "name": "Tommy", "popularity": 181.41463414634146 }, { "name": "Cecil", "popularity": 173 }, { "name": "Troy", "popularity": 153.85714285714286 }, { "name": "Sam", "popularity": 151.3846153846154 }, { "name": "Wesley", "popularity": 150.7450980392157 }, { "name": "Joel", "popularity": 135.96610169491527 }, { "name": "Bryan", "popularity": 133.90196078431373 }, { "name": "Charlie", "popularity": 126.64179104477611 }, { "name": "Milton", "popularity": 121.86666666666666 } ] } ] }, { "state": "UT", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Colleen", "popularity": 30.78125 }, { "name": "Vickie", "popularity": 19.523809523809526 }, { "name": "Joy", "popularity": 18.528301886792452 }, { "name": "Beth", "popularity": 17.91304347826087 }, { "name": "Kay", "popularity": 17.350877192982455 }, { "name": "Maxine", "popularity": 17.015625 }, { "name": "Jill", "popularity": 16.896103896103895 }, { "name": "Wendy", "popularity": 16.1123595505618 }, { "name": "Marsha", "popularity": 15.767857142857142 }, { "name": "Leslie", "popularity": 15.58904109589041 }, { "name": "Annette", "popularity": 13.717647058823529 }, { "name": "Terry", "popularity": 12.254545454545454 }, { "name": "Carla", "popularity": 12.178571428571429 }, { "name": "Laurie", "popularity": 11.382716049382717 }, { "name": "Cindy", "popularity": 10.931034482758621 } ] }, { "gender": "M", "by_name": [ { "name": "Glen", "popularity": 32.71875 }, { "name": "Troy", "popularity": 30.267857142857142 }, { "name": "Jay", "popularity": 27.16883116883117 }, { "name": "Dan", "popularity": 26.142857142857142 }, { "name": "Bryan", "popularity": 25.88235294117647 }, { "name": "Bradley", "popularity": 23.055555555555557 }, { "name": "Don", "popularity": 22.50537634408602 }, { "name": "Jeff", "popularity": 22 }, { "name": "Dean", "popularity": 19.974025974025974 }, { "name": "Chris", "popularity": 19.033898305084747 }, { "name": "Duane", "popularity": 18.517241379310345 }, { "name": "Gordon", "popularity": 17.53012048192771 }, { "name": "Bob", "popularity": 16.654545454545456 }, { "name": "Jon", "popularity": 15.65079365079365 }, { "name": "Wesley", "popularity": 15.549019607843137 } ] } ] }, { "state": "VA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Rosa", "popularity": 83.98484848484848 }, { "name": "Myrtle", "popularity": 79.96363636363637 }, { "name": "Nellie", "popularity": 79.71666666666667 }, { "name": "Lucy", "popularity": 79.6875 }, { "name": "Mattie", "popularity": 73.60377358490567 }, { "name": "Bessie", "popularity": 70 }, { "name": "Pearl", "popularity": 66.08333333333333 }, { "name": "Ella", "popularity": 64.22388059701493 }, { "name": "Elsie", "popularity": 62.756410256410255 }, { "name": "Lillie", "popularity": 59.93846153846154 }, { "name": "Emily", "popularity": 59.53703703703704 }, { "name": "Minnie", "popularity": 58.92857142857143 }, { "name": "Rachel", "popularity": 57.69491525423729 }, { "name": "Carrie", "popularity": 55.63235294117647 }, { "name": "Alma", "popularity": 55.34848484848485 } ] }, { "gender": "M", "by_name": [ { "name": "Charlie", "popularity": 96.02985074626865 }, { "name": "Cecil", "popularity": 85.08928571428571 }, { "name": "Lewis", "popularity": 75.18055555555556 }, { "name": "Franklin", "popularity": 72.88524590163935 }, { "name": "Calvin", "popularity": 66.08108108108108 }, { "name": "Wesley", "popularity": 60.05882352941177 }, { "name": "Herman", "popularity": 59.92857142857143 }, { "name": "Milton", "popularity": 57.8 }, { "name": "Clyde", "popularity": 54.88 }, { "name": "Johnnie", "popularity": 54.84615384615385 }, { "name": "Harvey", "popularity": 50.96774193548387 }, { "name": "Benjamin", "popularity": 47.078947368421055 }, { "name": "Leslie", "popularity": 45.793103448275865 }, { "name": "Alvin", "popularity": 45.44155844155844 }, { "name": "Troy", "popularity": 44.607142857142854 } ] } ] }, { "state": "VT", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Marion", "popularity": 7.891089108910891 }, { "name": "Leona", "popularity": 6.903846153846154 }, { "name": "Rachel", "popularity": 6.406779661016949 }, { "name": "Laurie", "popularity": 6.271604938271605 }, { "name": "Arlene", "popularity": 5.3164556962025316 }, { "name": "Dianne", "popularity": 5.0181818181818185 }, { "name": "Pauline", "popularity": 4.666666666666667 }, { "name": "Marlene", "popularity": 4.3283582089552235 }, { "name": "Colleen", "popularity": 4.015625 }, { "name": "Wendy", "popularity": 4 }, { "name": "Gertrude", "popularity": 3.987012987012987 }, { "name": "Constance", "popularity": 3.736842105263158 }, { "name": "Lorraine", "popularity": 3.6721311475409837 }, { "name": "Beatrice", "popularity": 3.663157894736842 }, { "name": "Pearl", "popularity": 3.4 } ] }, { "gender": "M", "by_name": [ { "name": "Gordon", "popularity": 8.024096385542169 }, { "name": "Arnold", "popularity": 7.875 }, { "name": "Bradley", "popularity": 6.574074074074074 }, { "name": "Bernard", "popularity": 6.093457943925234 }, { "name": "Leo", "popularity": 6.036585365853658 }, { "name": "Duane", "popularity": 5.0344827586206895 }, { "name": "Leslie", "popularity": 4.482758620689655 }, { "name": "Francis", "popularity": 4.246666666666667 }, { "name": "Jonathan", "popularity": 4.188679245283019 }, { "name": "Leon", "popularity": 3.7051282051282053 }, { "name": "Dean", "popularity": 3.5974025974025974 }, { "name": "Frederick", "popularity": 3.016 }, { "name": "Todd", "popularity": 3 }, { "name": "Jon", "popularity": 2.7777777777777777 }, { "name": "Norman", "popularity": 2.7552447552447554 } ] } ] }, { "state": "WA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Colleen", "popularity": 52.375 }, { "name": "Kay", "popularity": 37.85964912280702 }, { "name": "Joy", "popularity": 34.64150943396226 }, { "name": "Terry", "popularity": 32.872727272727275 }, { "name": "Laurie", "popularity": 32.629629629629626 }, { "name": "Leslie", "popularity": 31.698630136986303 }, { "name": "Dianne", "popularity": 31.12727272727273 }, { "name": "Carla", "popularity": 31.107142857142858 }, { "name": "Christina", "popularity": 31.107142857142858 }, { "name": "Terri", "popularity": 30 }, { "name": "Marlene", "popularity": 29.970149253731343 }, { "name": "Jill", "popularity": 28.493506493506494 }, { "name": "Renee", "popularity": 28.28125 }, { "name": "Vicki", "popularity": 28.264367816091955 }, { "name": "Maxine", "popularity": 27.875 } ] }, { "gender": "M", "by_name": [ { "name": "Bob", "popularity": 71.01818181818182 }, { "name": "Dan", "popularity": 66.375 }, { "name": "Jeff", "popularity": 51.33870967741935 }, { "name": "Bradley", "popularity": 51.092592592592595 }, { "name": "Duane", "popularity": 49.327586206896555 }, { "name": "Jim", "popularity": 45.357142857142854 }, { "name": "Jon", "popularity": 44.98412698412698 }, { "name": "Chris", "popularity": 41.76271186440678 }, { "name": "Bryan", "popularity": 41.09803921568628 }, { "name": "Tom", "popularity": 37.92 }, { "name": "Wesley", "popularity": 37.666666666666664 }, { "name": "Micheal", "popularity": 37.43636363636364 }, { "name": "Dean", "popularity": 36.90909090909091 }, { "name": "Gordon", "popularity": 36.734939759036145 }, { "name": "Glen", "popularity": 34.984375 } ] } ] }, { "state": "WI", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kay", "popularity": 90.54385964912281 }, { "name": "Marlene", "popularity": 70.38805970149254 }, { "name": "Leona", "popularity": 68.40384615384616 }, { "name": "Colleen", "popularity": 64.359375 }, { "name": "Delores", "popularity": 59.80281690140845 }, { "name": "Jill", "popularity": 59.45454545454545 }, { "name": "Arlene", "popularity": 56.81012658227848 }, { "name": "Dianne", "popularity": 55.6 }, { "name": "Lynn", "popularity": 55.45360824742268 }, { "name": "Renee", "popularity": 53.40625 }, { "name": "Beth", "popularity": 53.18840579710145 }, { "name": "Laurie", "popularity": 52.44444444444444 }, { "name": "Carla", "popularity": 47.214285714285715 }, { "name": "Dawn", "popularity": 47.16981132075472 }, { "name": "Marian", "popularity": 46.91025641025641 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 110.8103448275862 }, { "name": "Jerome", "popularity": 95.86486486486487 }, { "name": "Arnold", "popularity": 77.28571428571429 }, { "name": "Dean", "popularity": 70.46753246753246 }, { "name": "Jon", "popularity": 69.06349206349206 }, { "name": "Bradley", "popularity": 68.51851851851852 }, { "name": "Todd", "popularity": 62.810526315789474 }, { "name": "Gordon", "popularity": 59.95180722891566 }, { "name": "Harvey", "popularity": 57.306451612903224 }, { "name": "Elmer", "popularity": 55.53846153846154 }, { "name": "Jeff", "popularity": 52.46774193548387 }, { "name": "Dan", "popularity": 52.392857142857146 }, { "name": "Joel", "popularity": 48.86440677966102 }, { "name": "Tom", "popularity": 47.78666666666667 }, { "name": "Glen", "popularity": 47 } ] } ] }, { "state": "WV", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Nellie", "popularity": 59.85 }, { "name": "Myrtle", "popularity": 49.27272727272727 }, { "name": "Maxine", "popularity": 43.609375 }, { "name": "Billie", "popularity": 42.372549019607845 }, { "name": "Wilma", "popularity": 38.95180722891566 }, { "name": "Leona", "popularity": 37.86538461538461 }, { "name": "Pearl", "popularity": 37.71666666666667 }, { "name": "Alma", "popularity": 36.121212121212125 }, { "name": "Stella", "popularity": 35.35087719298246 }, { "name": "Vickie", "popularity": 32.57142857142857 }, { "name": "Bessie", "popularity": 32.23076923076923 }, { "name": "Marsha", "popularity": 31.946428571428573 }, { "name": "Delores", "popularity": 30.802816901408452 }, { "name": "Margie", "popularity": 30.483870967741936 }, { "name": "Georgia", "popularity": 29.727272727272727 } ] }, { "gender": "M", "by_name": [ { "name": "Franklin", "popularity": 63.75409836065574 }, { "name": "Cecil", "popularity": 63.30357142857143 }, { "name": "Arnold", "popularity": 40.75 }, { "name": "Darrell", "popularity": 37.91428571428571 }, { "name": "Clyde", "popularity": 37.72 }, { "name": "Lewis", "popularity": 35.90277777777778 }, { "name": "Glen", "popularity": 35.09375 }, { "name": "Elmer", "popularity": 33.707692307692305 }, { "name": "Chester", "popularity": 31.171875 }, { "name": "Jimmie", "popularity": 30.65 }, { "name": "Leslie", "popularity": 25.844827586206897 }, { "name": "Herman", "popularity": 24.17142857142857 }, { "name": "Randall", "popularity": 23.67816091954023 }, { "name": "Lester", "popularity": 23.507246376811594 }, { "name": "Gene", "popularity": 23.380281690140844 } ] } ] }, { "state": "WY", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kay", "popularity": 4.666666666666667 }, { "name": "Maxine", "popularity": 3.828125 }, { "name": "Billie", "popularity": 3.5294117647058822 }, { "name": "Colleen", "popularity": 3.359375 }, { "name": "Carla", "popularity": 3.017857142857143 }, { "name": "Georgia", "popularity": 2.9545454545454546 }, { "name": "Terry", "popularity": 2.9454545454545453 }, { "name": "Terri", "popularity": 2.547945205479452 }, { "name": "Vicki", "popularity": 2.4827586206896552 }, { "name": "Laurie", "popularity": 2.2962962962962963 }, { "name": "Leslie", "popularity": 2.2054794520547945 }, { "name": "Charlene", "popularity": 2.1818181818181817 }, { "name": "Roberta", "popularity": 2.163265306122449 }, { "name": "Marsha", "popularity": 2.0892857142857144 }, { "name": "Vickie", "popularity": 1.9682539682539681 } ] }, { "gender": "M", "by_name": [ { "name": "Bob", "popularity": 8.036363636363637 }, { "name": "Dan", "popularity": 5.589285714285714 }, { "name": "Glen", "popularity": 5.28125 }, { "name": "Jim", "popularity": 4.75 }, { "name": "Troy", "popularity": 4.232142857142857 }, { "name": "Tom", "popularity": 3.7466666666666666 }, { "name": "Dean", "popularity": 3.7142857142857144 }, { "name": "Bill", "popularity": 3.5851063829787235 }, { "name": "Wesley", "popularity": 3.5294117647058822 }, { "name": "Jon", "popularity": 3.4285714285714284 }, { "name": "Bradley", "popularity": 3.3703703703703702 }, { "name": "Duane", "popularity": 3.310344827586207 }, { "name": "Leslie", "popularity": 3.206896551724138 }, { "name": "Don", "popularity": 3.161290322580645 }, { "name": "Jay", "popularity": 2.831168831168831 } ] } ] } ]
WITH __stage0 AS ( SELECT group_set, __lateral_join_bag.name__1, __lateral_join_bag.gender__1, floor((CASE WHEN group_set=1 THEN COALESCE(SUM(names.number),0) END)/MAX((CASE WHEN group_set=0 THEN COALESCE(SUM(names.number),0) END)) OVER ()*100000) as births_per_100k__1, __lateral_join_bag.state__2, floor((CASE WHEN group_set=2 THEN COALESCE(SUM(names.number),0) END)/MAX((CASE WHEN group_set=1 THEN COALESCE(SUM(names.number),0) END)) OVER (PARTITION BY __lateral_join_bag.name__1, __lateral_join_bag.gender__1)*100000) as births_per_100k__2 FROM `bigquery-public-data.usa_names.usa_1910_current` as names CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,2,1))) LEFT JOIN UNNEST([STRUCT(CASE WHEN group_set IN (1,2) THEN names.name END as name__1, CASE WHEN group_set IN (1,2) THEN names.gender END as gender__1, CASE WHEN group_set=2 THEN names.state END as state__2)]) as __lateral_join_bag WHERE ((floor(names.year/10))*10)<1970 GROUP BY 1,2,3,5 ) , __stage1 AS ( SELECT name__1 as name, gender__1 as gender, ANY_VALUE(CASE WHEN group_set=1 THEN births_per_100k__1 END) as births_per_100k, ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT( state__2 as state, births_per_100k__2 as births_per_100k ) END IGNORE NULLS ORDER BY births_per_100k__2 desc ) as by_state FROM __stage0 WHERE group_set NOT IN (0) GROUP BY 1,2 ORDER BY 3 desc ) , __stage2 AS ( SELECT group_set, CASE WHEN group_set IN (0,1,2) THEN by_state_0.state END as state__0, CASE WHEN group_set IN (1,2) THEN base.gender END as gender__1, CASE WHEN group_set=2 THEN base.name END as name__2, CASE WHEN group_set=2 THEN (by_state_0.births_per_100k-base.births_per_100k)/base.births_per_100k END as popularity__2 FROM __stage1 as base LEFT JOIN UNNEST(base.by_state) as by_state_0 CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,2,1))) WHERE base.births_per_100k>50 GROUP BY 1,2,3,4,5 ) , __stage3 AS ( SELECT CASE WHEN group_set=2 THEN 1 ELSE group_set END as group_set, state__0 as state__0, CASE WHEN group_set IN (1,2) THEN gender__1 END as gender__1, ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT( name__2 as name, popularity__2 as popularity ) END IGNORE NULLS ORDER BY popularity__2 desc LIMIT 15) as by_name__1 FROM __stage2 GROUP BY 1,2,3 ) SELECT state__0 as state, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( gender__1 as gender, by_name__1 as by_name ) END IGNORE NULLS ORDER BY gender__1 asc ) as by_gender FROM __stage3 GROUP BY 1 ORDER BY 1 asc
Malloy